GPGB_SUBREF_LST (SQL Table)	Index Back
Sub- Reference Codes list Record to store all possible Sub-reference codes. This will be used in payment processing to assign a sub-ref code to a calendar run. The Flag field is not currently used in the system.

GPGB_SUBREF_LST

(SQL Table)

Sub- Reference Codes list

Record to store all possible Sub-reference codes. This will be used in payment processing to assign a sub-ref code to a calendar run. The Flag field is not currently used in the system.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SEQ_NUM8 Number(8,0) INTEGER NOT NULL Sequence Number

2 GPGB_SUB_REF_CD Character(5) VARCHAR2(5) NOT NULL UK Sub-reference code - To cross-reference BACS payments with FPS submissions

3 FLAG Character(1) VARCHAR2(1) NOT NULL Flag

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SEQ_NUM8	Number(8,0)	INTEGER NOT NULL	Sequence Number
2	GPGB_SUB_REF_CD	Character(5)	VARCHAR2(5) NOT NULL	UK Sub-reference code - To cross-reference BACS payments with FPS submissions
3	FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag