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