BUDGET_IDBUDGET_START_DTBUDGET_RULE_CD01=Active to Inactive Status
02=Currency Code
03=Salary
Y/N Table Edit
Default Value: N
WCS_ECM_CYC_RUL(SQL Table) |
Index Back |
|---|---|
Open Cycle Job Change RulesUsed to store job change rules for compensation cycles. |
| # | 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 | BUDGET_RULE_CD |
Character(2) | VARCHAR2(2) NOT NULL |
Job change types.
01=Active to Inactive Status 02=Currency Code 03=Salary |
| 4 | WCS_ECM_EXCLUDED | Character(1) | VARCHAR2(1) NOT NULL |
Employee Exclusion Flag
Y/N Table Edit Default Value: N |