BUDGET_RULE_CD01=Active to Inactive Status
02=Currency Code
03=Salary
WCS_RULE_CD_VW(SQL View) |
Index Back |
|---|---|
Job Change Rule Codes ViewUsed to get job change rule codes. |
| SELECT %Substring(XLAT.FIELDVALUE, 1, 2) , XLAT.XLATLONGNAME FROM PSXLATITEM XLAT WHERE XLAT.FIELDNAME = 'BUDGET_RULE_CD' AND XLAT.EFF_STATUS = 'A' AND XLAT.EFFDT = ( SELECT MAX(ED.EFFDT) FROM PSXLATITEM ED WHERE XLAT.FIELDNAME = ED.FIELDNAME AND XLAT.FIELDVALUE = ED.FIELDVALUE AND ED.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUDGET_RULE_CD |
Character(2) | VARCHAR2(2) NOT NULL |
Job change types.
01=Active to Inactive Status 02=Currency Code 03=Salary |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |