GPGB_CAL_SUBREF

(SQL Table)
Index Back

Calendar Sub- Ref code map

Record to store Cal_run_id and Sub-reference codes mapping for the employee.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
3 GPGB_DEST_ACCT_NBR Character(35) VARCHAR2(35) NOT NULL UK Destination Account Number for EFT
4 GPGB_ORIG_ACCT_NBR Character(35) VARCHAR2(35) NOT NULL UK Originating Account Number for EFT
5 GPGB_SUB_REF_CD Character(5) VARCHAR2(5) NOT NULL UK Sub-reference code - To cross-reference BACS payments with FPS submissions