FC_REPORT_TO_VW(SQL View) |
Index Back |
|---|---|
Supervisor/Employee ListThis view returns a list of supervisors and their current employees and the employees ' point in time Job information based on the begin date of the particular horizon. |
| SELECT SUPERVISOR_ID , BUSINESS_UNIT_GL , BEGIN_DT , EMPLID , EMPL_RCD , EFFDT , EFFSEQ , DEPTID , JOBCODE , EMPL_STATUS , HOLIDAY_SCHEDULE , STD_HOURS FROM PS_FC_EE_FCST_LST |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SUPERVISOR_ID |
Character(11) | VARCHAR2(11) NOT NULL | Supervisor ID |
| 2 | BUSINESS_UNIT_GL |
Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 3 | BEGIN_DT |
Date(10) | DATE | Begin Date |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 6 | EFFDT | Date(10) | DATE | Effective Date |
| 7 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 8 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 9 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 10 | EMPL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Employee Status
A=Active D=Deceased I=Inactive L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration |
| 11 | HOLIDAY_SCHEDULE | Character(6) | VARCHAR2(6) NOT NULL | Holiday Schedule |
| 12 | STD_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Standard Hours |