WCS_RUN_MERIT(SQL Table) |
Index Back |
|---|---|
WCS Merit Load Run Cntl Rec |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GB_GROUP_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table: GB_GROUP_TBL |
| 2 | EP_REVIEW_TYPE |
Character(8) | VARCHAR2(8) NOT NULL |
Review type
Prompt Table: SP_MER_REVW_VW |
| 3 | SP_FROM_DATE |
Date(10) | DATE NOT NULL |
From Date - used in Salary Planning
Prompt Table: SP_MER_FR_DT_VW |
| 4 | SP_TO_DATE |
Date(10) | DATE NOT NULL |
To Date - used in Salary Planning
Prompt Table: SP_MER_TO_DT_VW |
| 5 | SUBMIT_PB | Character(1) | VARCHAR2(1) NOT NULL |
Submit
N=No Y=Yes Default Value: N |
| 6 | WCS_RUN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Run Status
I=Invalid N=No Y=Yes |
| 7 | ASOFDATE | Date(10) | DATE NOT NULL | As of Date |
| 8 | ACTION | Character(3) | VARCHAR2(3) NOT NULL |
Action
Prompt Table: ACTION_TBL |
| 9 | ACTION_REASON | Character(3) | VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table: ACTN_REASON_TBL |
| 10 | UPD_FUTURE_ROW_SW | Character(1) | VARCHAR2(1) NOT NULL |
Update Future Rows
N=No Y=Yes Y/N Table Edit Default Value: N |
| 11 | CMP_DONT_ABSORB | Character(1) | VARCHAR2(1) NOT NULL |
Don't Absorb Changes
N=No Y=Yes Y/N Table Edit Default Value: N |