PERSON_DT_SETUP(SQL Table) |
Index Back |
|---|---|
PERSONAL_DATA snapshot settingContains the settings for the PERSONAL_DATA snapshot creation. ADDRESS_TYPE - what address_type to use in the main address fields. ADDRESS_TYPE_OTH - what address_type to use in the Other Address fields. Include Primary NID? |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ADDRESS_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Address Type
Default Value: HOME Prompt Table: ADDRESS_TYP_TBL |
| 2 | ADDRESS_TYPE_OTH | Character(4) | VARCHAR2(4) NOT NULL |
Address Type
Default Value: MAIL Prompt Table: ADDRESS_TYP_TBL |
| 3 | COUNTRY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Flag to determine whether to include the installed country extension fields
Y/N Table Edit Default Value: Y |
| 4 | USF_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Flag to determine whether to include the US Federal fields
Y/N Table Edit Default Value: N |
| 5 | PHONE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Flag to determine whether to include the Phone Data
Y/N Table Edit Default Value: Y |
| 6 | SMOKER_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Flag to determine whether to include the Phone Data
Y/N Table Edit Default Value: Y |
| 7 | SA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Flag to determine whether to include the Phone Data
Y/N Table Edit Default Value: N |