SCC_TEMP_IDPrompt Table: SCC_SL_TMP_ID
Prompt Table: SCC_TRNSAC_DTLS
SCC_SL_TMPID_VW(SQL View) |
Index Back |
|---|---|
View to select Temp Id'sView to select Temp Id's with Primary Name details |
| SELECT DISTINCT A.SCC_TEMP_ID ,A.SCC_TRANSAC_CD ,B.FIRST_NAME ,B.LAST_NAME ,B.NAME FROM PS_SCC_STG_CONSTIT A , PS_SCC_STG_NAMES B WHERE A.SCC_TEMP_ID = B.SCC_TEMP_ID AND A.SCC_STG_STATUS <> 'CN' AND B.NAME_TYPE ='PRI' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_TEMP_ID |
Number(16,0) | DECIMAL(16) NOT NULL |
Temp Constituent ID
Prompt Table: SCC_SL_TMP_ID |
| 2 | SCC_TRANSAC_CD | Character(25) | VARCHAR2(25) NOT NULL |
Transaction
Prompt Table: SCC_TRNSAC_DTLS |
| 3 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 4 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 5 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |