WCS_RUN_MER_AET(SQL Table) |
Index Back |
|---|---|
WCS Merit Load AE State record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | WCS_RUN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
WCS Merit Load Process run control type.
B=Calculate Group Budgets G=Load Group Increases M=Load Merit Increases S=Calculate Group Increases |
| 5 | GB_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table: GB_GROUP_SEC_VW |
| 6 | EP_REVIEW_TYPE | Character(8) | VARCHAR2(8) NOT NULL |
Review type
Prompt Table: SP_MER_REVW_VW |
| 7 | SP_FROM_DATE | Date(10) | DATE |
From Date - used in Salary Planning
Prompt Table: SP_MER_FR_DT_VW |
| 8 | SP_TO_DATE | Date(10) | DATE |
To Date - used in Salary Planning
Prompt Table: SP_MER_TO_DT_VW |
| 9 | ASOFDATE | Date(10) | DATE | As of Date |
| 10 | ACTION | Character(3) | VARCHAR2(3) NOT NULL | Action |
| 11 | ACTION_REASON | Character(3) | VARCHAR2(3) NOT NULL | Reason Code |
| 12 | UPD_FUTURE_ROW_SW | Character(1) | VARCHAR2(1) NOT NULL |
Update Future Rows
N=No Y=Yes |
| 13 | CMP_DONT_ABSORB | Character(1) | VARCHAR2(1) NOT NULL |
Don't Absorb Changes
N=No Y=Yes |