SFA_PG_SAS_AET

(SQL Table)
Index Back

Pell SAS Import State Rec

For processing import Pell SAS Files

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 SCCFP_MAP_ID Number(15,0) DECIMAL(15) NOT NULL Mapping ID - the unique key that identifies the file mapping
5 SFA_PG_SAS_RUN_DT Date(10) DATE PELL SAS Run Date
6 SFA_PG_SAS_SEQ_NBR Number(9,0) DECIMAL(9) NOT NULL PELL SAS - Sequence Number
7 SFA_PG_BATCH_ID_00 Character(26) VARCHAR2(26) NOT NULL Pell Batch ID