ADD_APPT_JPN(SQL Table) |
Index Back |
|---|---|
Additional Appointments tableThis table is used to hold Additional Appointment data for the Japanese "Kenmu" feature. Additional Appointments are essentially additional job roles held by an employee. This table is a child of JOB. /*Japan HR 16-Aug-2000-0*/ Newly created. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DATA |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | ADD_APPT_ID |
Number(3,0) | SMALLINT NOT NULL |
Additional Appointment ID
Default Value: 1 |
| 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 | SUPV_LVL_ID | Character(8) | VARCHAR2(8) NOT NULL |
Supervisor Level ID for use in capability grade system
Prompt Table: SUPVSR_LVL_TBL |
| 10 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |
| 11 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department SetID |
| 12 | SETID_SUPV_LVL | Character(5) | VARCHAR2(5) NOT NULL | Stored setid for the Supervisor Level. |
| 13 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location SetID |
| 14 | COMPANY2 | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: INTCPX_CPY_JPN |
| 15 | DEPTID2 | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_ADD_VW_JPN |
| 16 | SUPV_LVL_ID2 | Character(8) | VARCHAR2(8) NOT NULL |
Supervisor Level
Prompt Table: INTCPX_SPV_JPN |
| 17 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 18 | EXP_END_DATE | Date(10) | DATE | Expected End Date |
| 19 | END_DATE | Date(10) | DATE | End Date |
| 20 | COST_RATE | Number(2,0) | SMALLINT NOT NULL | Cost Rate |