COMPANYPrompt Table: COMPANY_TBL
Y/N Table Edit
Default Value: N
Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY
Prompt Table: CURRENCY_CD_TBL
Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_RT_TYPE
Prompt Table: RT_TYPE_TBL
SAL_PLAN_CONTRL(SQL Table) |
Index Back |
|---|---|
Salary Plan Control - CompanySAL_PLAN_CONTRL is a control record for the Salary Planning application. It contains the company-level defaults which are brought into the DEPT_INCR_CNTRL record, which is by department. It contains information regarding the budget period being planned and the start date of the planning process. When a new salary planning cycle begins, this is the first record which must be changed during plan setup to establish the new defaults for the planning period. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 2 | BUDGET_START_DT | Date(10) | DATE NOT NULL | Budget Start Date |
| 3 | BUDGET_END_DT | Date(10) | DATE NOT NULL | Budget End Date |
| 4 | SAL_PLAN_START_DT | Date(10) | DATE NOT NULL | Salary Planning Start Date |
| 5 | ANNIVERSARY_SW | Character(1) | VARCHAR2(1) NOT NULL |
Employee Anniversary Raises
Y/N Table Edit Default Value: N |
| 6 | NEW_HIRE_ELIG_DT | Date(10) | DATE | New Hire Eligibility Date |
| 7 | SAL_PLAN_EFFDT | Date(10) | DATE | Salary Plan Effective Date |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL |
| 9 | EXCHNG_TO_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Currency Rate Type
Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_RT_TYPE Prompt Table: RT_TYPE_TBL |