RETROPAY_ACCT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RETROPAY_SEQ_NO	Character(8)	VARCHAR2(8) NOT NULL	Retro Pay Sequence Number Prompt Table: RETROPAY_RQST
2	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
3	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: PAYGROUP_TBL
4	PAY_END_DT	Date(10)	DATE NOT NULL	Pay Period End Date Prompt Table: PAY_CALENDAR
5	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ? Y/N Table Edit
6	PAGE_NUM	Number(4,0)	SMALLINT NOT NULL	Page #
7	LINE_NUM	Number(2,0)	SMALLINT NOT NULL	Line #
8	ADDL_NBR	Number(3,0)	SMALLINT NOT NULL	Additional Pay Line #
9	EARNS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type of Earning 1=Regular Hourly 2=Regular Salary 3=Overtime 4=Other Earns 5=Other Hours
10	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code Prompt Table: EARNINGS_CLE_VW
11	SEQ_NO	Number(2,0)	SMALLINT NOT NULL	Sequence Number
12	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code
13	GL_PAY_TYPE	Character(6)	VARCHAR2(6) NOT NULL	General Ledger Pay Type
14	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
15	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
16	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
17	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
18	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: JOB.BUSINESS_UNIT Prompt Table: BUS_UNIT_TBL_HR