EMPLIDPrompt Table: PEOPLE_SRCH
INSTITUTIONPrompt Table: INSTITUTION_TBL
SCC_VOC_MSG_SEQSCC_SFP_R_EMPVW(SQL View) |
Index Back |
|---|---|
Message Map ViewMap uuid message id to a particular transaction |
| SELECT M.EMPLID ,H.INSTITUTION , M.SCC_VOC_MSG_SEQ FROM PS_SCC_SFA_MSG_MAP M , PS_SCC_SFP_RUN_HIS H WHERE M.PROCESS_INSTANCE= H.PROCESS_INSTANCE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 3 | SCC_VOC_MSG_SEQ |
Number(15,0) | DECIMAL(15) NOT NULL | Vocado message sequence number |