HR_WP_ACTV_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	ACTIVITY_DT	Date(10)	DATE	Activity Date
5	HR_WP_ACTVTY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Wage Progression Activity Type 1=Wage Advancement 2=Job Change 3=Payroll Update 4=Manual
6	HR_WP_ID	Character(10)	VARCHAR2(10) NOT NULL	Wage Progression Run ID
7	ACCUM_HRS	Signed Number(9,3)	DECIMAL(7,3) NOT NULL	Employee Hours
8	HR_WP_ADJ_PROG_HRS	Signed Number(9,3)	DECIMAL(7,3) NOT NULL	Adj Progression Hours
9	HR_WP_MAX_ADV_HRS	Number(8,3)	DECIMAL(7,3) NOT NULL	Required Hours
10	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code SetID
11	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
12	SETID_SALARY	Character(5)	VARCHAR2(5) NOT NULL	Salary SetID
13	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan
14	GRADE	Character(3)	VARCHAR2(3) NOT NULL	Salary Grade
15	STEP	Number(2,0)	SMALLINT NOT NULL	Step
16	STEP_ENTRY_DT	Date(10)	DATE	Step Entry Date
17	ADJ_STEP_ENTRY_DT	Date(10)	DATE	Adj Step Entry Date
18	WP_INITIATED	Character(1)	VARCHAR2(1) NOT NULL	Initiated By 1=Payroll Update 2=Wage Progression
19	HR_WP_EST_ADV_DT	Date(10)	DATE	Estimated Advance
20	POSTED_DATE	Date(10)	DATE	Date Posted
21	HR_WP_TRANS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Transaction Type
22	BARG_UNIT	Character(4)	VARCHAR2(4) NOT NULL	Bargaining Unit 1=Bargaining Unit 1 2=Bargaining Unit 2
23	SETID_LBR_AGRMNT	Character(5)	VARCHAR2(5) NOT NULL	Labor Agreement SetID
24	LABOR_AGREEMENT	Character(6)	VARCHAR2(6) NOT NULL	Labor Agreement
25	HR_WP_TYPE_CATGRY	Character(1)	VARCHAR2(1) NOT NULL	Progression Type 1=Reported Time Based 2=Elapsed Time Based
26	HOLD_PROG_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Stop Wage Progression Y/N Table Edit Default Value: N
27	WAGE_PROG_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Wage Progression Plan
28	HR_WP_PROG_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Wage Progression Status. Indicates where the Employee is in the Wage Progression cycle. 1=Not Qualified 2=Almost Qualified 3=Qualified - Approval Required 4=Approved 5=Not Approved 6=Advanced 7=Completed Wage Progression Default Value: 1
29	STD_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Standard Hours
30	STD_HRS_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Standard Work Period
31	APPROVER_ID	Character(11)	VARCHAR2(11) NOT NULL	Approver EmplID
32	APPRVL_DT	Date(10)	DATE	Approval Date
33	HR_WP_EXCPTN_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Exception Flag Y/N Table Edit Default Value: N
34	HR_WP_EXCPTN_APPR	Character(1)	VARCHAR2(1) NOT NULL	Acknowledge Exception Y/N Table Edit Default Value: N
35	HR_WP_EXCPTN_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Acknowledged By
36	HR_WP_EXCPTN_DTTM	DateTime(26)	TIMESTAMP	Acknowledged On
37	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
38	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
39	LEAVE_HOURS	Number(9,3)	DECIMAL(8,3) NOT NULL	Leave Hours
40	HR_WP_LEAVE_LMT_HR	Number(8,2)	DECIMAL(7,2) NOT NULL	Maximum Leave Hours
41	HR_WP_PROCESS_APPR	Character(1)	VARCHAR2(1) NOT NULL	Select
42	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
43	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.