HR_WP_IDB=Labor Agreement
G=Group ID
S=Salary Plan
Default Value: B
Prompt Table: GB_GROUP_SEC_VW
1=Job Change Update
2=Payroll Update
3=Qualification
4=Approve Employees
5=Advance Employees
HR_WP_ID_TBL(SQL Table) |
Index Back |
|---|---|
Wage Progression Run IDWage Progression Run ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HR_WP_ID |
Character(10) | VARCHAR2(10) NOT NULL | Wage Progression Run ID |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | WP_PROG_BASIS | Character(1) | VARCHAR2(1) NOT NULL |
Wage Prog Population Basis
B=Labor Agreement G=Group ID S=Salary Plan Default Value: B |
| 4 | GB_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table: GB_GROUP_SEC_VW |
| 5 | HR_WP_LAST_PROCESS | Character(1) | VARCHAR2(1) NOT NULL |
Last Process Run
1=Job Change Update 2=Payroll Update 3=Qualification 4=Approve Employees 5=Advance Employees |
| 6 | HR_WP_JC_DTTM | DateTime(26) | TIMESTAMP | Job Changes Process Date |
| 7 | HR_WP_PY_DTTM | DateTime(26) | TIMESTAMP | Payroll Update Process Date |
| 8 | HR_WP_QLFY_DTTM | DateTime(26) | TIMESTAMP | Qualification Process Date |
| 9 | HR_WP_APPR_DTTM | DateTime(26) | TIMESTAMP | Approve for Advancement Date |
| 10 | HR_WP_ADV_DTTM | DateTime(26) | TIMESTAMP | Advancement Process Date |
| 11 | LAST_RUN_DTM | DateTime(26) | TIMESTAMP | Last Run On |