| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 ORG_PLAN_JPN |
Character(3) |
VARCHAR2(3) NOT NULL |
Tracks one possible view of the employees in a company.
Prompt Table:
IDO_ORGPLAN_JPN
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
ACTIVE_WRKR_VW
|
| 3 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
Prompt Table:
EE_RCD_JPN_VW
|
| 4 |
SEQUENCE_JPN |
Number(4,0) |
SMALLINT NOT NULL |
Sequence
Default Value: 1
|
| 5 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
Prompt Table:
ACTION_TBL
|
| 6 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table:
ACTN_REASON_TBL
|
| 7 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
BUSUNIT_HR_VW
|
| 8 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPT_TBL
|
| 9 |
PREV_BUS_UNIT_JPN |
Character(5) |
VARCHAR2(5) NOT NULL |
Previous Business Unit for an employee
Prompt Table:
BUSUNIT_HR_VW
|
| 10 |
PREV_DEPTID_JPN |
Character(10) |
VARCHAR2(10) NOT NULL |
Previous Department for an employee.
Prompt Table:
DEPT_TBL
|
| 11 |
SUPV_LVL_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Supervisor Level ID for use in capability grade system
Prompt Table:
SUPVSR_LVL_TBL
|
| 12 |
IDO_ACTION_JPN |
Character(2) |
VARCHAR2(2) NOT NULL |
Tracks the Action being applied to a Tamatsuki Post.
10=Open Post
20=Assigned
30=Closed Post
40=Create Additional Appointment
Default Value: 20
|
| 13 |
START_DATE_JPN |
Date(10) |
DATE |
Tracks the beginning date of an additional appointment assignment.
|
| 14 |
EXP_END_DATE_JPN |
Date(10) |
DATE |
Tracks the date in the future when the additional appointment assignment is expected to be completed.
|
| 15 |
END_DATE_JPN |
Date(10) |
DATE |
The actual date that an additional appointment assignment was completed.
|
| 16 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 17 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_TBL
|
| 18 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
JOBCODE_TBL
|
| 19 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 20 |
PROC_STAT_JPN |
Character(1) |
VARCHAR2(1) NOT NULL |
Tracks the status of rows associated with a process.
E=Error prevented processing
N=Not Processed
W=Row processed but check log
Y=Processed
Default Value: N
|