WCS_CYC_RLE_LOG(SQL Table) |
Index Back |
|---|---|
Open Cycle Job Changes LogJob changes during open cycle. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(10) | VARCHAR2(10) NOT NULL | Budget ID | |
| 2 | Date(10) | DATE NOT NULL | Budget Start Date | |
| 3 | Number(10,0) | DECIMAL(10) NOT NULL | Internal beginning node range number | |
| 4 | Character(11) | VARCHAR2(11) NOT NULL | Employee ID | |
| 5 | Number(3,0) | SMALLINT NOT NULL | Empl Record | |
| 6 | Date(10) | DATE |
Effective Date
Default Value: %date |
|
| 7 | Number(3,0) | SMALLINT NOT NULL | Effective Sequence | |
| 8 | Character(2) | VARCHAR2(2) NOT NULL |
Job change types.
01=Active to Inactive Status 02=Currency Code 03=Salary |
|
| 9 | WCS_ECM_EXCLUDED | Character(1) | VARCHAR2(1) NOT NULL |
Employee Exclusion Flag
Y/N Table Edit Default Value: N |
| 10 | ACTION | Character(3) | VARCHAR2(3) NOT NULL | Action |
| 11 | ACTION_REASON | Character(3) | VARCHAR2(3) NOT NULL | Reason Code |
| 12 | OLD_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Old currency code. |
| 13 | NEW_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | New Currency Code |
| 14 | CHANGE_PCT | Signed Number(8,3) | DECIMAL(6,3) NOT NULL | Change Percent |
| 15 | OLD_COMPRATE | Number(19,6) | DECIMAL(18,6) NOT NULL | Old compensation rate. |
| 16 | NEW_COMPRATE | Number(19,6) | DECIMAL(18,6) NOT NULL | New Compensation Rate |
| 17 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 18 | WCS_NODE_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Node Status
CLC=Calculated CME=Completed with Errors CMP=Completed CNF=Confirmed INP=In Progress PSB=Pushed Back RTL=Ready to Load SUB=Submitted |
| 19 | RUN_DTTM | DateTime(26) | TIMESTAMP | Run Date and Time |