ADDRESS_TYPEPrompt Table: HCR_ADDR_TYP_I
D=Display Only
F=Full Edit
N=Do Not Display
U=Edit - No Delete
Default Value: N
Default Value: N
TYPE_CNTL_ADDR(SQL Table) |
Index Back |
|---|---|
Address type control |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ADDRESS_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Address Type
Prompt Table: HCR_ADDR_TYP_I |
| 2 | TYPE_CONTROL | Character(1) | VARCHAR2(1) NOT NULL |
Type Control
D=Display Only F=Full Edit N=Do Not Display U=Edit - No Delete Default Value: N |
| 3 | SYSTEM_DATA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Default Value: N |