AA_ONE_JPN_VW(SQL View) |
Index Back |
|---|---|
Additional Appt History ViewLists all Additional Appointment History for one Main Appointment. |
| SELECT A.EMPLID , A.EMPL_RCD , B.EMPL_RCD , B.EFFDT , B.ACTION , B.BUSINESS_UNIT , B.COMPANY , B.DEPTID , B.LOCATION , B.SUPV_LVL_ID , C.INTCP_COMPANY2 , C.INTCP_DEPTID2 , C.INTCP_SUPV_LVL_ID2 , C.START_DATE_JPN , C.EXP_END_DATE_JPN , C.END_DATE_JPN FROM PS_PER_ORG_ASGN A , PS_JOB B , PS_JOB_JR C WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.MAIN_APPT_NUM_JPN AND B.APPT_TYPE = '1' AND B.EMPLID = C.EMPLID AND B.EMPL_RCD = C.EMPL_RCD AND B.EFFDT = C.EFFDT AND B.EFFSEQ = C.EFFSEQ |
| # | 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 | EMPL_RCD_JPN |
Signed Number(4,0) | DECIMAL(3) NOT NULL | Tracks the empl_rcd of an additional appointment. This is used in records that also lists the main appointment empl_rcd. |
| 4 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | ACTION_REASON_JPN | Character(3) | VARCHAR2(3) NOT NULL |
This field displays the actions available for an Additional Appointment employee.
ADL=Assign Kenmu DTA=Data Change TER=Release Kenmu |
| 6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUSUNIT_HR_VW |
| 7 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 8 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 9 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |
| 10 | SUPV_LVL_ID | Character(8) | VARCHAR2(8) NOT NULL |
Supervisor Level ID for use in capability grade system
Prompt Table: SUPVSR_LVL_TBL |
| 11 | INTCP_COMPANY2 | Character(3) | VARCHAR2(3) NOT NULL |
External Company
Prompt Table: INTCPX_CPY_JPN |
| 12 | INTCP_DEPTID2 | Character(10) | VARCHAR2(10) NOT NULL |
External DeptID
Prompt Table: INTCPX_DPT_JPN |
| 13 | INTCP_SUPV_LVL_ID2 | Character(8) | VARCHAR2(8) NOT NULL |
External Supv Lvl
Prompt Table: INTCPX_SPV_JPN |
| 14 | START_DATE_JPN | Date(10) | DATE | Tracks the beginning date of an additional appointment assignment. |
| 15 | EXP_END_DATE_JPN | Date(10) | DATE | Tracks the date in the future when the additional appointment assignment is expected to be completed. |
| 16 | END_DATE_JPN | Date(10) | DATE | The actual date that an additional appointment assignment was completed. |