WCS_CYC_RLE_LOG

(SQL Table)
Index Back

Open Cycle Job Changes Log

Job 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