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 | BUDGET_ID | Character(10) | VARCHAR2(10) NOT NULL | Budget ID |
2 | BUDGET_START_DT | Date(10) | DATE NOT NULL | Budget Start Date |
3 | TREE_NODE_NUM | Number(10,0) | DECIMAL(10) NOT NULL | Internal beginning node range number |
4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
5 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
6 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
7 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
8 | BUDGET_RULE_CD | 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 |