HR_WP_ACTVY_HST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
5	ACTIVITY_DT	Date(10)	DATE	Activity Date
6	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
7	HR_WP_ID	Character(10)	VARCHAR2(10) NOT NULL	Wage Progression Run ID
8	ACCUM_HRS	Signed Number(9,3)	DECIMAL(7,3) NOT NULL	Employee Hours
9	HR_WP_ADJ_PROG_HRS	Signed Number(9,3)	DECIMAL(7,3) NOT NULL	Adj Progression Hours
10	HR_WP_MAX_ADV_HRS	Number(8,3)	DECIMAL(7,3) NOT NULL	Required Hours
11	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code Set ID
12	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
13	SETID_SALARY	Character(5)	VARCHAR2(5) NOT NULL	Salary Set ID
14	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan
15	GRADE	Character(3)	VARCHAR2(3) NOT NULL	Salary Grade
16	STEP	Number(2,0)	SMALLINT NOT NULL	Step
17	STEP_ENTRY_DT	Date(10)	DATE	Step Entry Date
18	ADJ_STEP_ENTRY_DT	Date(10)	DATE	Adj Step Entry Date
19	WP_INITIATED	Character(1)	VARCHAR2(1) NOT NULL	Initiated By 1=Payroll Update 2=Wage Progression
20	HR_WP_EST_ADV_DT	Date(10)	DATE	Estimated Advance
21	POSTED_DATE	Date(10)	DATE	Date Posted
22	HR_WP_TRANS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Transaction Type
23	BARG_UNIT	Character(4)	VARCHAR2(4) NOT NULL	Bargaining Unit 1=Bargaining Unit 1 2=Bargaining Unit 2
24	SETID_LBR_AGRMNT	Character(5)	VARCHAR2(5) NOT NULL	Labor Agreement SetID
25	LABOR_AGREEMENT	Character(6)	VARCHAR2(6) NOT NULL	Labor Agreement
26	HR_WP_TYPE_CATGRY	Character(1)	VARCHAR2(1) NOT NULL	Progression Type 1=Reported Time Based 2=Elapsed Time Based
27	HOLD_PROG_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Stop Wage Progression Y/N Table Edit Default Value: N
28	WAGE_PROG_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Wage Progression Plan
29	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
30	STD_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Standard Hours
31	STD_HRS_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Standard Work Period
32	APPROVER_ID	Character(11)	VARCHAR2(11) NOT NULL	Approver Empl ID
33	APPRVL_DT	Date(10)	DATE	Approval Date
34	HR_WP_EXCPTN_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Exception Flag Y/N Table Edit Default Value: N
35	HR_WP_EXCPTN_APPR	Character(1)	VARCHAR2(1) NOT NULL	Acknowledge Exception Y/N Table Edit Default Value: N
36	HR_WP_EXCPTN_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Acknowledged By
37	HR_WP_EXCPTN_DTTM	DateTime(26)	TIMESTAMP	Acknowledged On
38	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
39	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
40	LEAVE_HOURS	Number(9,3)	DECIMAL(8,3) NOT NULL	Leave Hours
41	HR_WP_LEAVE_LMT_HR	Number(8,2)	DECIMAL(7,2) NOT NULL	Maximum Leave Hours
42	HR_WP_PROCESS_APPR	Character(1)	VARCHAR2(1) NOT NULL	Select
43	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.
44	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.