PROCESS_INSTANCEEMPLIDEMPL_RCDEFFDTEFFSEQSUPERVISOR_IDSUPERVISOR_ERNPrompt Table: HCSC_SPVRPT_VW
Prompt Table: DEPT_TBL
WCS_ECM_JOB_TMP(SQL Table) |
Index Back |
|---|---|
Supervisor ID Relationship VwThis view is used to relate employees with their Supervisors, based on the SupervisorID stored on Job. This view is used as the hierarchy source. when building a tree. Since SupervisorID only records the supervising person, and not the supervising job, the view has some built-in assumptions regarding matching a supervisor is potential multiple jobs with the correct direct reports. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | EFFDT |
Date(10) | DATE | Effective Date |
| 5 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 6 | SUPERVISOR_ID |
Character(11) | VARCHAR2(11) NOT NULL | Supervisor ID |
| 7 | SUPERVISOR_ERN |
Number(3,0) | SMALLINT NOT NULL | This is used to hold the Employment Record Number of a supervisor. |
| 8 | EMPL_ID_RCD | Character(20) | VARCHAR2(20) NOT NULL |
Job concatenated key.
Prompt Table: HCSC_SPVRPT_VW |
| 9 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 10 | NAME_PSFORMAT | Character(50) | VARCHAR2(50) NOT NULL | A Person's name in the Peoplesoft Format (basically LN,FN MI |
| 11 | DEPTID2 | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 12 | EFFDT_OTH | Date(10) | DATE | Other Effective Date |
| 13 | JOB_EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Job Effective Sequence |