GPFR_AF_EE_SIT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
2	GPFR_AF_APPL	Character(10)	VARCHAR2(10) NOT NULL	Application Framework - Application
3	GPFR_AF_EXTRACT_ID	Character(18)	VARCHAR2(18) NOT NULL	Application Framework - Extraction ID
4	GPFR_AF_SNDREF	Character(10)	VARCHAR2(10) NOT NULL	Application Framework - Sending Reference
5	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
6	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID
7	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
8	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
9	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Number Default Value: 0
10	GPFR_AF_SIT_BGN_DT	Date(10)	DATE NOT NULL	Application Framework - Situation Begin Date
11	GPFR_AF_NODE_SET	Character(16)	VARCHAR2(16) NOT NULL	Application Framework - Node Set
12	GPFR_AF_SIT_END_DT	Date(10)	DATE	Application Framework - Situation End Date
13	GPFR_AF_SIT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Application Framework - Situation Status Y/N Table Edit Default Value: N
14	GPFR_AF_SITIND_HIR	Character(1)	VARCHAR2(1) NOT NULL	Application Framework - Situation Indicator Hire Y/N Table Edit Default Value: N
15	GPFR_AF_SITIND_END	Character(1)	VARCHAR2(1) NOT NULL	Application Framework - End Situation Indicator Y/N Table Edit Default Value: N
16	GPFR_AF_EXT_BGN_DT	Date(10)	DATE	Application Framework - Extraction Begin Date
17	GPFR_AF_EXT_END_DT	Date(10)	DATE	Application Framework - Extraction End Date
18	GPFR_AF_UF_01	Character(50)	VARCHAR2(50) NOT NULL	User Fields
19	GPFR_AF_UF_02	Character(50)	VARCHAR2(50) NOT NULL	User Fields
20	GPFR_AF_UF_03	Character(50)	VARCHAR2(50) NOT NULL	User Fields
21	GPFR_AF_UF_04	Character(50)	VARCHAR2(50) NOT NULL	User Fields
22	GPFR_AF_UF_05	Character(50)	VARCHAR2(50) NOT NULL	User Fields
23	GPFR_AF_UF_06	Character(50)	VARCHAR2(50) NOT NULL	User Fields
24	GPFR_AF_UF_07	Character(50)	VARCHAR2(50) NOT NULL	User Fields
25	GPFR_AF_UF_08	Character(50)	VARCHAR2(50) NOT NULL	User Fields
26	GPFR_AF_UF_09	Character(50)	VARCHAR2(50) NOT NULL	User Fields
27	GPFR_AF_UF_10	Character(50)	VARCHAR2(50) NOT NULL	User Fields