FO_RESLOAD_VW

(SQL View)
Index Back

SELECT A.FO_RESLOAD_ID , A.FO_RESLOAD_DESC , A.RUN_CNTL_ID , A.FO_RESLOAD_STATUS , A.FO_ROW_ADD_OPRID , A.FO_ROW_UPD_DTTM FROM PS_FO_RESLOAD A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FO_RESLOAD_ID Character(11) VARCHAR2(11) NOT NULL Resume Load ID

Default Value: NEXT

2 FO_RESLOAD_DESC Character(50) VARCHAR2(50) NOT NULL Resume Load Description
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 FO_RESLOAD_STATUS Character(3) VARCHAR2(3) NOT NULL Resume Load Status
10=In Preparation
20=Ready for Load
30=Load In Progress
40=Loaded
50=Error

Default Value: 10

5 FO_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
6 FO_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime