HR_WP_ADVC_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	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
5	HR_WP_ID	Character(10)	VARCHAR2(10) NOT NULL	Wage Progression Run ID
6	AS_OF_DATE	Date(10)	DATE	As of Date
7	ACTIVITY_DT	Date(10)	DATE	Activity Date
8	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
9	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
10	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
11	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
12	STEP	Number(2,0)	SMALLINT NOT NULL	Step
13	WPP_STOP_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Y/N Flag to indicated that Wage Progression is stopped on this Assignment.
14	UPDATE_FUTURE_ROW	Character(1)	VARCHAR2(1) NOT NULL	Update Future Rows
15	UPD_WP_HIST_BY	Character(1)	VARCHAR2(1) NOT NULL	Process Employees By 1=Company/Paygroup 2=Labor Agreement 3=Group 4=Salary Administration Plan
16	SETID_SALARY	Character(5)	VARCHAR2(5) NOT NULL	Salary SetID
17	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan
18	WP_PROG_BASIS	Character(1)	VARCHAR2(1) NOT NULL	Wage Prog Population Basis B=Labor Agreement G=Group ID S=Salary Plan
19	HR_WP_TYPE_CATGRY	Character(1)	VARCHAR2(1) NOT NULL	Progression Type 1=Reported Time Based 2=Elapsed Time Based
20	HR_WP_EST_ADV_DT	Date(10)	DATE	Estimated Advance
21	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
22	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
23	FILENAME	Character(80)	VARCHAR2(80) NOT NULL	File Name