GPFR_SALPLAN_VW(SQL View) |
Index Back |
|---|---|
Standard Hours and FrequencyRetrieves Standard Hours and Frequency from JOB and SALARY_PLAN |
| SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , B.STD_HOURS ,B.STD_HRS_FREQUENCY FROM PS_JOB A , PS_SAL_PLAN_TBL B WHERE A.SETID_SALARY = B.SETID AND A.SAL_ADMIN_PLAN = B.SAL_ADMIN_PLAN AND B.EFFDT = ( SELECT MAX(B2.EFFDT) FROM PS_SAL_PLAN_TBL B2 WHERE A.SETID_SALARY = B2.SETID AND A.SAL_ADMIN_PLAN = B2.SAL_ADMIN_PLAN AND B2.EFFDT <= A.EFFDT ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | STD_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Standard Hours |
| 5 | STD_HRS_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL | Standard Work Period |