Skip to main content

Data tables

Suggest edit Updated on May 17, 2021
Note: These tables are specific to database administrators. All cells filled with N/A in the below tables indicates that there is no value in the database for that particular cell.

P_ADDRESS

This table stores address information about contacts and business units. Replace calls to this table with calls to your data tables.

Columns

Name Data typeSize Scale Nulls? Dflt
ACTIVEVARCHAR216N/ANoN/A
ADDRESS1VARCHAR2128N/ANoN/A
ADDRESS2VARCHAR2128N/ANoN/A
ADDRESS3VARCHAR2128N/ANoN/A
ADDRESS4VARCHAR2128N/ANoN/A
ADDRESS5VARCHAR2128N/ANoN/A
ADDRESSIDVARCHAR216N/AYesN/A
ADDRESSTYPEVARCHAR232N/ANoN/A
CITYVARCHAR2128N/ANoN/A
COUNTRYCODEVARCHAR28N/ANoN/A
DOMAINIDVARCHAR216N/ANoN/A
DOMAINTYPEVARCHAR216N/ANoN/A
FROMDATEDATEN/ANoN/A
POSTALCODEVARCHAR232N/ANoN/A
PRIMARYADDRESSVARCHAR216N/ANoN/A
PROVINCEVARCHAR2128N/ANoN/A
PXCREATEDATETIMEDATEN/ANoN/A
PXCREATEOPERATORVARCHAR2128N/ANoN/A
PXCREATEOPNAMEVARCHAR2128N/ANoN/A
PXCREATESYSTEMIDVARCHAR232N/ANoN/A
PXUPDATEDATETIMEDATEN/ANoN/A
PXUPDATEOPERATORVARCHAR2128N/ANoN/A
PXUPDATEOPNAMEVARCHAR2128N/ANoN/A
PXUPDATESYSTEMIDVARCHAR232N/ANoN/A
PYSTATEVARCHAR2128N/ANoN/A
REGIONVARCHAR2128N/ANoN/A
SUBREGIONVARCHAR2128N/ANoN/A
TODATEDATEN/ANoN/A

Constraints

Column Constraint Referenced columns
ADDRESSIDP_ADDRESS_V2_PKN/A

P_ORGANIZATION

This table stores information about organizations. Replace calls to this table with calls to your data tables.

Columns

Name Data typeSize Scale Nulls? Dflt
ACTIVEVARCHAR216N/ANoN/A
DESCRIPTIONVARCHAR2255N/ANoN/A
EMPLOYEECOUNTVARCHAR216N/ANoN/A
ENDDATEDATEN/ANoN/A
FACEBOOKIDVARCHAR232N/ANoN/A
FACEBOOKURLVARCHAR264N/ANoN/A
FAXVARCHAR216N/ANoN/A
INDUSTRYVARCHAR232N/ANoN/A
ISPARENTVARCHAR216N/ANoN/A
LEGALENTITYTYPEVARCHAR264N/ANoN/A
LINKEDINIDVARCHAR232N/ANoN/A
LINKEDINURLVARCHAR264N/ANoN/A
ORGANIZATIONIDVARCHAR216N/AYesN/A
ORGANIZATIONNAMEVARCHAR2255N/ANoN/A
ORGANIZATIONTYPEVARCHAR216N/ANoN/A
PRIMARYEMAILIDVARCHAR2255N/ANoN/A
PRIMARYPHONENUMBERVARCHAR216N/ANoN/A
PXCREATEDATETIMEDATEN/ANoN/A
PXCREATEOPERATORVARCHAR2128N/ANoN/A
PXCREATEOPNAMEVARCHAR2128N/ANoN/A
PXCREATESYSTEMIDVARCHAR232N/ANoN/A
PXUPDATEDATETIMEDATEN/ANoN/A
PXUPDATEOPERATORVARCHAR2128N/ANoN/A
PXUPDATEOPNAMEVARCHAR2128N/ANoN/A
PXUPDATESYSTEMIDVARCHAR232N/ANoN/A
REVENUENUMERIC162NoN/A
SECONDARYEMAILIDVARCHAR2255N/ANoN/A
SECONDARYPHONENUMBERVARCHAR216N/ANoN/A
STARTDATEDATEN/ANoN/A
TAXIDVARCHAR216N/ANoN/A
TERRITORYIDVARCHAR264N/ANoN/A
TWITTERIDVARCHAR232N/ANoN/A
TWITTERURLVARCHAR232N/ANoN/A
WEBSITEVARCHAR2255N/ANoN/A

Constraints

Column Constraint Referenced columns
ORGANIZATIONIDP_ORGANIZATION_V2_PKN/A

P_CONTACT

This table is a sample table that stores information about contacts. Replace calls to this table with calls to your data tables.

Columns

Name Data typeSize Scale Nulls? Dflt
ACTIVEVARCHAR216N/ANoN/A
ASSISTANTEMAILVARCHAR2128N/ANoN/A
ASSISTANTNAMEVARCHAR2128N/ANoN/A
ASSISTANTPHONEVARCHAR232N/ANoN/A
BESTTIMETOCALLVARCHAR216N/ANoN/A
COMMPREFERENCEBYEMAILVARCHAR232N/ANoN/A
COMMPREFERENCEBYFAXVARCHAR232N/ANoN/A
COMMPREFERENCEBYMAILVARCHAR232N/ANoN/A
COMMPREFERENCEBYPHONEVARCHAR232N/ANoN/A
COMPANYNAMEVARCHAR2128N/ANoN/A
CONTACTIDVARCHAR216N/AYesN/A
CONTACTTYPEVARCHAR216N/ANoN/A
DATEOFBIRTHDATEN/ANoN/A
DEPARTMENTNAMEVARCHAR2128N/ANoN/A
FACEBOOKIDVARCHAR2128N/ANoN/A
FACEBOOKURLVARCHAR2255N/ANoN/A
FAXVARCHAR232N/ANoN/A
FIRSTNAMEVARCHAR264N/ANoN/A
GENDERVARCHAR216N/ANoN/A
INDUSTRYVARCHAR232N/ANoN/A
JOBTITLEVARCHAR2128N/ANoN/A
LANGUAGEPREFERENCEVARCHAR264N/ANoN/A
LASTNAMEVARCHAR264N/ANoN/A
LINKEDINIDVARCHAR2255N/ANoN/A
LINKEDINURLVARCHAR2255N/ANoN/A
MARITALSTATUSVARCHAR232N/ANoN/A
MARKETINGBYEMAILVARCHAR216N/ANoN/A
MARKETINGBYMAILVARCHAR216N/ANoN/A
MARKETINGBYPHONEVARCHAR216N/ANoN/A
MIDDLENAMEVARCHAR264N/ANoN/A
NATIONALIDVARCHAR264N/ANoN/A
PARENTCONTACTIDVARCHAR216N/ANoN/A
PRIMARYEMAILVARCHAR2128N/ANoN/A
PRIMARYEMAILTYPEVARCHAR232N/ANoN/A
PRIMARYPHONENUMBERVARCHAR232N/ANoN/A
PRIMARYPHONETYPEN/ANoN/A
PRIORITYNOTEVARCHAR264N/ANoN/A
PXCREATEDATETIMEDATEN/ANoN/A
PXCREATEOPERATORVARCHAR2128N/ANoN/A
PXCREATEOPNAMEVARCHAR2128N/ANoN/A
PXCREATESYSTEMIDVARCHAR232N/ANoN/A
PXUPDATEDATETIMEDATEN/ANoN/A
PXUPDATEOPERATORVARCHAR2128N/ANoN/A
PXUPDATEOPNAMEVARCHAR2128N/ANoN/A
PXUPDATESYSTEMIDVARCHAR232N/ANoN/A
PYTIMEZONEVARCHAR216N/ANoN/A
SALUTATIONVARCHAR216N/ANoN/A
SECONDARYEMAILVARCHAR2128N/ANoN/A
SECONDARYEMAILTYPEVARCHAR232N/ANoN/A
SECONDARYPHONENUMBERVARCHAR232N/ANoN/A
SECONDARYPHONETYPEVARCHAR232N/ANoN/A
SUFFIXVARCHAR216N/ANoN/A
TAXIDVARCHAR216N/ANoN/A
TERRITORYIDVARCHAR264N/ANoN/A
TERTIARYPHONENUMBERVARCHAR232N/ANoN/A
TERTIARYPHONETYPEVARCHAR232N/ANoN/A
TWITTERIDVARCHAR2128N/ANoN/A
TWITTERURLVARCHAR2255N/ANoN/A

Constraints

Column Constraint Referenced columns
CONTACTIDP_CONTACT_V2_PKN/A

P_ROLE

This table stores roles for policy, contact, and business unit links. Some workflows use the role type to determine processing steps. Add your own affiliations for account, contact, and business unit associations.

Columns

Name Data typeSize Scale Nulls? Dflt
ACTIVEVARCHAR216N/ANoN/A
DESCRIPTIONVARCHAR2255N/ANoN/A
PXCREATEDATETIMEDATEN/ANoN/A
PXCREATEOPERATORVARCHAR2128N/ANoN/A
PXCREATEOPNAMEVARCHAR2128N/ANoN/A
PXCREATESYSTEMIDVARCHAR232N/ANoN/A
PXUPDATEDATETIMEDATEN/ANoN/A
PXUPDATEOPERATORVARCHAR2128N/ANoN/A
PXUPDATEOPNAMEVARCHAR2128N/ANoN/A
PXUPDATESYSTEMIDVARCHAR232N/ANoN/A
ROLEIDVARCHAR216N/AYesN/A
ROLENAMEVARCHAR2255N/ANoN/A
ROLETYPEVARCHAR216N/ANoN/A

Constraints

Column Constraint Referenced columns
ROLEIDP_ROLE_V2_PKN/A

ORGANIZATION_INS

This table stores information that describes the industry in which a business operates.

Columns

Name Data typeSize Scale Nulls? Dflt
ACCOUNTVALUENUMERICN/ANoN/A
ORGANIZATIONIDVARCHAR216N/AYesN/A
SICCODEVARCHAR24N/ANoN/A
NAICSCODEVARCHAR26N/ANoN/A

Constraints

Column Constraint Referenced columns
ORGANIZATIONIDORGANIZATION_INS_PKN/A

IIF_AGENCY

This table stores agency Information for all LOBs. Agency details will be picked up from this table while creating the policy from Pega Underwriting for Insurance.

Columns

Name Data typeSize Scale Nulls? Dflt
PXCREATEDATETIMEDATEN/AYesN/A
PXCREATEOPNAMEVARCHAR2128N/AYesN/A
PXCREATEOPERATORVARCHAR2128N/AYesN/A
PXCREATESYSTEMIDVARCHAR232N/AYesN/A
PXINSNAMEVARCHAR2128N/AYesN/A
PXOBJCLASSVARCHAR296N/AYesN/A
PXUPDATEDATETIMEDATEN/AYesN/A
PXUPDATEOPNAMEVARCHAR2128N/AYesN/A
PXUPDATEOPERATORVARCHAR2128N/AYesN/A
PXUPDATESYSTEMIDVARCHAR232N/AYesN/A
PYLABELVARCHAR264N/AYesN/A
PYRULESETNAMEVARCHAR264N/AYesN/A
PZINSKEYVARCHAR2255N/ANoN/A
PZPVSTREAMBLOBN/AYesN/A
AGENCYCODEVARCHAR232N/AYesN/A
AGENCYNAMEVARCHAR232N/AYesN/A
CODEVARCHAR232N/AYesN/A
ACTIVEVARCHAR25N/AYesN/A

Constraints

Constraintname PEGAINS_INTERFACE_AGENCYTES_PK
TypePRIMARY
DisableNo
Referenced SchemaN/A
Referenced TableN/A
Cascade on DeleteNo
Check ConditionN/A
Deferrable?No
No Validate?No
Initially Deferred?No
RELY (Do Not Enforce)?No

Constraint column details

Column Constraint Referenced columns
PZINSKEYPEGAINS_INTERFACE_AGENCYTES_PKN/A

IIF_AGENT

This table stores agent Information (agent ID, name, agency code) for all LOBs. Agent details will be picked up from this table while creating the policy from Pega Underwriting for Insurance.

Columns

Name Data typeSize Scale Nulls? Dflt
PXCREATEDATETIMEDATEN/AYesN/A
PXCREATEOPNAMEVARCHAR2128N/AYesN/A
PXCREATEOPERATORVARCHAR2128N/AYesN/A
PXCREATESYSTEMIDVARCHAR232N/AYesN/A
PXINSNAMEVARCHAR2128N/AYesN/A
PXOBJCLASSVARCHAR296N/AYesN/A
PXUPDATEDATETIMEDATEN/AYesN/A
PXUPDATEOPNAMEVARCHAR2128N/AYesN/A
PXUPDATEOPERATORVARCHAR2128N/AYesN/A
PXUPDATESYSTEMIDVARCHAR232N/AYesN/A
PYLABELVARCHAR264N/AYesN/A
PYRULESETNAMEVARCHAR264N/AYesN/A
PZINSKEYVARCHAR2255N/ANoN/A
PZPVSTREAMBLOBN/AYesN/A
AGENCYCODEVARCHAR232N/AYesN/A
AGENTIDVARCHAR232N/AYesN/A
FIRSTNAMEVARCHAR232N/AYesN/A
LASTNAMEVARCHAR232N/AYesN/A
EMAILVARCHAR232N/AYesN/A

Constraints

Constraintname PEGAINS_INTERFACE_AGENTTEST_PK
TypePRIMARY
DisableNo
Referenced SchemaN/A
Referenced TableN/A
Cascade On DeleteNo
Check ConditionN/A
Deferrable?No
Constraintname PEGAINS_INTERFACE_AGENTTEST_PK
No Validate?No
Initially Deferred?No
RELY (Do Not Enforce)?No

IIF_SICDIVISION

This table stores SIC information for all kinds of business divisions, including effective and termination dates. This information will be picked up from this table while creating the policy from Pega Underwriting for Insurance.

Columns

Name Data typeSize Scale Nulls? Dflt
PXCREATEDATETIMEDATEN/AYesN/A
PXCREATEOPNAMEVARCHAR2128N/AYesN/A
PXCREATEOPERATORVARCHAR2128N/AYesN/A
PXCREATESYSTEMIDVARCHAR232N/AYesN/A
PXINSNAMEVARCHAR2128N/AYesN/A
PXOBJCLASSVARCHAR296N/AYesN/A
PXUPDATEDATETIMEDATEN/AYesN/A
PXUPDATEOPNAMEVARCHAR2128N/AYesN/A
PXUPDATEOPERATORVARCHAR2128N/AYesN/A
PXUPDATESYSTEMIDVARCHAR232N/AYesN/A
PYLABELVARCHAR264N/AYesN/A
PYRULESETNAMEVARCHAR264N/AYesN/A
PZINSKEYVARCHAR2255N/AYesN/A
PZPVSTREAMBLOBN/AYesN/A
IDVARCHAR220N/AYesN/A
EFFECTIVEDATEVARCHAR220N/AYesN/A
TERMDATEVARCHAR220N/AYesN/A
DESCRIPTIONVARCHAR2255N/AYesN/A
EXPRESSIONNAMEVARCHAR220N/AYesN/A

Constraints

Constraintname IIF_SICDIVISION_PK
TypePRIMARY
DisableNo
Referenced SchemaN/A
Referenced TableN/A
Cascade On DeleteNo
Check ConditionN/A
Deferrable?No
Constraintname IIF_SICDIVISION_PK
No Validate?No
Initially Deferred?No
RELY (Do Not Enforce)?No

Constraint column details

Column Constraint Referenced columns
IDSYS_C0023923N/A
EFFECTIVEDATESYS_C0023924N/A

IIF_SICFACTOR

This table stores SIC information for all kinds of industry codes, including effective and termination dates, and SIC High and Low factors. This information will be picked up from this table while creating the policy from Pega Underwriting for Insurance.

Columns

Name Data typeSize Scale Nulls? Dflt
PXCREATEDATETIMEDATEN/AYesN/A
PXCREATEOPNAMEVARCHAR2128N/AYesN/A
PXCREATEOPERATORVARCHAR2128N/AYesN/A
PXCREATESYSTEMIDVARCHAR232N/AYesN/A
PXINSNAMEVARCHAR2128N/AYesN/A
PXOBJCLASSVARCHAR296N/AYesN/A
PXUPDATEDATETIMEDATEN/AYesN/A
PXUPDATEOPNAMEVARCHAR2128N/AYesN/A
PXUPDATEOPERATORVARCHAR2128N/AYesN/A
PXUPDATESYSTEMIDVARCHAR232N/AYesN/A
PYLABELVARCHAR264N/AYesN/A
PYRULESETNAMEVARCHAR264N/AYesN/A
PZINSKEYVARCHAR2255N/AYesN/A
PZPVSTREAMBLOBN/AYesN/A
DIVISIONIDVARCHAR220N/AYesN/A
EFFECTIVEDATEVARCHAR220N/ANoN/A
TERMDATEVARCHAR220N/AYesN/A
DESCRIPTIONVARCHAR2255N/AYesN/A
EXPRESSIONNAMEVARCHAR220N/AYesN/A
FACTORVARCHAR220N/AYesN/A
GROUPIDVARCHAR220N/AYesN/A
SICHIGHVARCHAR220N/ANoN/A
SICLOWVARCHAR220N/ANoN/A

Constraints

Constraintname IIF_SICFACTOR_PK
TypePRIMARY
DisableNo
Referenced SchemaN/A
Referenced TableN/A
Cascade On DeleteNo
Check ConditionN/A
Deferrable?No
No Validate?No
Initially Deferred?No
RELY (Do Not Enforce)?No

Constraint column details

Column Constraint Referenced columns
EFFECTIVEDATESYS_C0023926N/A
SICHIGHSYS_C0023927N/A
SICLOWSYS_C0023928N/A

IIF_SICGROUP

This table stores SIC information for all kinds of industry group descriptions, including effective and termination dates. This information will be picked up from this table while creating the policy from Pega Underwriting for Insurance.

Columns

Name Data typeSize Scale Nulls? Dflt
PXCREATEDATETIMEDATEN/AYesN/A
PXCREATEOPNAMEVARCHAR2128N/AYesN/A
PXCREATEOPERATORVARCHAR2128N/AYesN/A
PXCREATESYSTEMIDVARCHAR232N/AYesN/A
PXINSNAMEVARCHAR2128N/AYesN/A
PXOBJCLASSVARCHAR296N/AYesN/A
PXUPDATEDATETIMEDATEN/AYesN/A
PXUPDATEOPNAMEVARCHAR2128N/AYesN/A
PXUPDATEOPERATORVARCHAR2128N/AYesN/A
PXUPDATESYSTEMIDVARCHAR232N/AYesN/A
PYLABELVARCHAR264N/AYesN/A
PYRULESETNAMEVARCHAR264N/AYesN/A
PZINSKEYVARCHAR2255N/AYesN/A
Name Data typeSize Scale Nulls? Dflt
PZPVSTREAMBLOBN/AYesN/A
DIVISIONIDVARCHAR220N/AYesN/A
EFFECTIVEDATEVARCHAR220N/ANoN/A
TERMDATEVARCHAR220N/AYesN/A
DESCRIPTIONVARCHAR2255N/AYesN/A
EXPRESSIONNAMEVARCHAR220N/AYesN/A
IDVARCHAR220N/ANoN/A

Constraints

Constraintname IIF_SICGROUP_PK
TypePRIMARY
DisableNo
Referenced SchemaN/A
Referenced TableN/A
Cascade On DeleteNo
Check ConditionN/A
Deferrable?No
No Validate?No
Initially Deferred?No
RELY (Do Not Enforce)?No

Constraint column details

Column Constraint Referenced columns
EFFECTIVEDATESYS_C0023930N/A
IDSYS_C0023931N/A

IIF_SICTONAICS

This table stores NAIC codes for all SIC codes and corresponding descriptions. This information will be picked up from this table while creating the policy from Pega Underwriting for Insurance.

Columns

Name Data typeSize Scale Nulls? Dflt
PXCREATEDATETIMEDATEN/AYesN/A
PXCREATEOPNAMEVARCHAR2128N/AYesN/A
PXCREATEOPERATORVARCHAR2128N/AYesN/A
PXCREATESYSTEMIDVARCHAR232N/AYesN/A
PXINSNAMEVARCHAR2128N/AYesN/A
Name Data typeSize Scale Nulls? Dflt
PXOBJCLASSVARCHAR296N/AYesN/A
PXUPDATEDATETIMEDATEN/AYesN/A
PXUPDATEOPNAMEVARCHAR2128N/AYesN/A
PXUPDATEOPERATORVARCHAR2128N/AYesN/A
PXUPDATESYSTEMIDVARCHAR232N/AYesN/A
PYLABELVARCHAR264N/AYesN/A
PYRULESETNAMEVARCHAR264N/AYesN/A
PZINSKEYVARCHAR2255N/AYesN/A
PZPVSTREAMBLOBN/AYesN/A
NAICSCODEVARCHAR220N/ANoN/A
SICCODEVARCHAR220N/ANoN/A
NAICSCODEDESCRIPTIONVARCHAR2255N/AYesN/A
SICCODEDESCRIPTIONVARCHAR2255N/AYesN/A

Constraints

Constraintname IIF_SICTONAICS_PK
TypePRIMARY
DisableNo
Referenced Schema
Referenced Table
Cascade On DeleteNo
Check Condition
Deferrable?No
No Validate?No
Initially Deferred?No
RELY (Do Not Enforce)?No

Constraint column details

Column Constraint Referenced columns
NAICSCODESYS_C0023933
SICCODESYS_C0023934

IIF_VEHICLES

This table stores vehicle make, model, and year of manufacture information. These details will be picked up from this table while creating the policy from Pega Underwriting for Insurance.

Columns

Name Data typeSize Scale Nulls? Dflt
PXCREATEDATETIMEDATEYes
PXCREATEOPNAMEVARCHAR2128Yes
PXCREATEOPERATORVARCHAR2128Yes
PXCREATESYSTEMIDVARCHAR232Yes
PXINSNAMEVARCHAR2128Yes
PXOBJCLASSVARCHAR296Yes
PXUPDATEDATETIMEDATEYes
PXUPDATEOPNAMEVARCHAR2128Yes
PXUPDATEOPERATORVARCHAR2128Yes
PXUPDATESYSTEMIDVARCHAR232Yes
PYLABELVARCHAR264Yes
PYRULESETNAMEVARCHAR264Yes
PZINSKEYVARCHAR2255No
PZPVSTREAMBLOBYes
DESCRIPTIONVARCHAR264Yes
MAKEVARCHAR264Yes
MODELVARCHAR264Yes
VINPREFIXVARCHAR264Yes
YEARVARCHAR264Yes

Constraints

Constraint name PEGAINS_INTERFACE_VEHICLES_PK
TypePRIMARY
DisableNo
Referenced Schema
Referenced Table
Cascade On DeleteNo
Check Condition
Deferrable?No
No Validate?No
Initially Deferred?No
RELY (Do Not Enforce)?No

Constraint column details

Column Constraint Referenced columns
PZINSKEYSYS_C0017547
Did you find this content helpful? YesNo

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us