GVT_RTND_SP_VW(SQL View) |
Index Back |
|---|---|
Retained Sal Plan ViewSAL_PLAN_TBL is a reference table for Salary Administration Plans. Different plans may exist in an organization based on geographical location, currency, or company, to name a few. Each plan would have its own salary ranges for each salary grade. Gvt_Pay_Plan was added as a high order key to create Federal Salary Administration Plans. 07/28/03 Lee - ICE508075000 - Add substring to viewtext for SQL validator. |
| SELECT %Substring(setid, 1, 2) ,sal_admin_plan ,effdt ,eff_status ,descr ,descrshort ,gvt_sal_basis ,gvt_geog_scope ,std_hours ,currency_cd ,salary_matrix_cd ,company FROM PS_SAL_PLAN_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GVT_RTND_PAY_PLAN |
Character(2) | VARCHAR2(2) NOT NULL | Retained Pay Plan |
| 2 | GVT_RTND_SAL_PLAN |
Character(4) | VARCHAR2(4) NOT NULL | Retained Pay Table |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 7 | GVT_SAL_BASIS | Character(1) | VARCHAR2(1) NOT NULL |
Salary Basis
A=Annual Basis B=Biweekly Basis H=Hourly Basis M=Monthly Basis Default Value: A |
| 8 | GVT_GEOG_SCOPE | Character(1) | VARCHAR2(1) NOT NULL |
Geographic Scope of Plan
L=Local Special Rate N=Nationwide Special Rate W=Worldwide Special Rate X=Regular Rate Default Value: L |
| 9 | STD_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL |
Standard Hours
Default Value: INSTALLATION.STD_HRS_DEFAULT |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL |
| 11 | SALARY_MATRIX_CD | Character(5) | VARCHAR2(5) NOT NULL |
Salary Matrix Code
Prompt Table: SAL_MATRIX_TBL |
| 12 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |