SCC_UIDEMPLIDPrompt Table: PERSON
NAME_TYPEPrompt Table: NAME_TYPE_TBL
SCC_NAME_TYPE_I(SQL View) |
Index Back |
|---|---|
CS Name Type Interface ViewCS Name Type Interface View |
| SELECT ' ' ,EMPLID ,NAME_TYPE FROM PS_HCR_PER_NAME_I |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_UID |
Character(100) | VARCHAR2(100) NOT NULL | Universal Hub ID |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 3 | NAME_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Type of Name
Prompt Table: NAME_TYPE_TBL |