GPCN_FILE_INFO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	GPCN_FILE_NO	Character(20)	VARCHAR2(20) NOT NULL	This field captures the Personal File number.
4	GPCN_ARCHIVE_FMT	Character(2)	VARCHAR2(2) NOT NULL	This field captures the Archive Format. 01=No File Existing 02=Original Copy 03=Secondary Copy 04=Film 05=Original,Secondary Copy & File 06=Original Copy, Secondary Copy 07=Original Copy and Film 08=Secondary Copy and Film 09=Other
5	GPCN_TRANSFER_INDT	Date(10)	DATE	This field captures the Transfer In date.
6	GPCN_TRANSFER_OUTD	Date(10)	DATE	This field captures the Transfer Out Date.
7	GPCN_TARGET_ORG	Character(50)	VARCHAR2(50) NOT NULL	This field captures the Target Organization .
8	GPCN_TRANS_INSRC	Character(20)	VARCHAR2(20) NOT NULL	This field captures the Transfer In Source.
9	GPCN_TRANS_OUTDEST	Character(20)	VARCHAR2(20) NOT NULL	Transfer Out Destination.
10	GPCN_STORE_ORG	Character(50)	VARCHAR2(50) NOT NULL	This field captures the Staore Location ( Original Copy ).
11	GPCN_STORE_SEC	Character(50)	VARCHAR2(50) NOT NULL	This field captures the Store Location (Second Copy)