OPRIDRUN_CNTL_IDEMPLIDPrompt Table: SAD_SL_NAT_E_VW
SAD_SL_NATIONALITYPrompt Table: SAD_SL_NAT_1_VW
SAD_SL_NATIONALTY2Prompt Table: SAD_SL_NAT_2_VW
SAD_SL_51N_RUNC(SQL Table) |
Index Back |
|---|---|
Msg 51 Nationality Run Control |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: SAD_SL_NAT_E_VW |
| 4 | SAD_SL_NATIONALITY |
Character(4) | VARCHAR2(4) NOT NULL |
Nationality
Prompt Table: SAD_SL_NAT_1_VW |
| 5 | SAD_SL_NATIONALTY2 |
Character(4) | VARCHAR2(4) NOT NULL |
Nationality2
Prompt Table: SAD_SL_NAT_2_VW |