GPCN_CNAO_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	GPCN_CNAO_RPT_TYP	Character(1)	VARCHAR2(1) NOT NULL	This field is to store CNAO report type for Global Payroll China. P=Payroll Information S=Shared Information Default Value: 2
6	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
7	GPCN_ACC_PER_YEAR	Number(4,0)	SMALLINT NOT NULL	This field is to store accounting period year for Global Payroll China.
8	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
9	PRD_END_DT	Date(10)	DATE	Pay Period End Date
10	FILE_HANDLE	Character(2)	VARCHAR2(2) NOT NULL	File Handle
11	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUS_UNIT_TBL_HR
12	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
13	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
14	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
15	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
16	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
17	PYMT_DT	Date(10)	DATE	Payment Date
18	COUNTER	Signed Number(6,0)	DECIMAL(5) NOT NULL	Counter
19	TEMP_FLD	Character(1)	VARCHAR2(1) NOT NULL	Temporary Field for App Engine
20	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
21	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
22	EMPL_CTG	Character(6)	VARCHAR2(6) NOT NULL	Employee Category
23	ACC_PERIOD_MAP_CHN	Character(1)	VARCHAR2(1) NOT NULL	Accounitng Period mapping for China E=Earn Date P=Pay Date
24	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
25	GPCN_PAY_PER_NUM	Character(2)	VARCHAR2(2) NOT NULL	This field is to store pay period number for Global Payroll China.
26	GPCN_ACC_STRT_DT	Character(8)	VARCHAR2(8) NOT NULL	This field is to store accounting start date for Global Payroll China.
27	GPCN_ACC_END_DT	Character(8)	VARCHAR2(8) NOT NULL	This field is to store accounting period end date for Global Payroll China.
28	GPCN_ACC_PER_NUM	Character(15)	VARCHAR2(15) NOT NULL	This field is to store accounting period number for Global Payroll China.
29	GENDER_CHN	Character(20)	VARCHAR2(20) NOT NULL	This field is to store gender information for Global Payroll China.
30	GPCN_MONTH_FROM	Number(2,0)	SMALLINT NOT NULL	This field is to store accounting month from information for Global Payroll China.
31	GPCN_MONTH_TO	Number(2,0)	SMALLINT NOT NULL	This field is to store accounting month to information for Global Payroll China.