SCCFP_MAP_IDPrompt Table: SCCFP_CNTXT_DFN
SFA_PGMAPDFN_VW(SQL View) |
Index Back |
|---|---|
FileParser Map Definition View |
| SELECT SCCFP_MAP_ID , SCCFP_MAP_NAME , SCCFP_CNTXT_ID FROM PS_SCCFP_MAP_DFN WHERE SCCFP_MAP_STATUS='A' AND SCCFP_MAP_NAME IN ('PELL SAS IMPORT','PELL SAS ON DEMAND IMPORT','PELL SAS IMPORT 2024-2025', 'PELL SAS ON DEMAND IMP 2024-25') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCCFP_MAP_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Mapping ID - the unique key that identifies the file mapping |
| 2 | SCCFP_MAP_NAME | Character(30) | VARCHAR2(30) NOT NULL | File Mapping name - the user key to a File Mapping |
| 3 | SCCFP_CNTXT_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Context ID - the unique key that identifies the file context
Prompt Table: SCCFP_CNTXT_DFN |