EMPLIDEMPL_RCDEFFDTDefault Value: %date
EFFSEQROLEUSERPrompt Table: PERSON_NAME
Prompt Table: ADDRESS_TYP_TBL
MIL_RANK_POSTAL(SQL Table) |
Index Back |
|---|---|
Military Stakeholder PostalContains the postal notification information for stakeholders who will recieve postal notifications for military rank transactions If the stakeholder is entered here, this implies that the stakeholder does not have on-line accesss to PeopleSoft HCM. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | ROLEUSER |
Character(30) | VARCHAR2(30) NOT NULL |
Role User
Prompt Table: PERSON_NAME |
| 6 | MIL_POSTAL_NOTIFY | Date(10) | DATE | Mailing Date |
| 7 | ADDRESS_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Address Type
Prompt Table: ADDRESS_TYP_TBL |
| 8 | ADDRESSLONG | Long Character | CLOB | Address Long |