| # |
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
Default Value: 0
|
| 4 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 5 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 6 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 7 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
Prompt Table:
RANK_CHNG_STAT
|
| 8 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table:
ACTN_REASON_TBL
Set Control Field: ACTION
|
| 9 |
ROLENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table:
PSROLEDEFN_VW
|
| 10 |
MIL_RANK_APPL_DT |
Date(10) |
DATE |
Application Date
|
| 11 |
MIL_APPROVAL_START |
Date(10) |
DATE |
Approval Start Date
|
| 12 |
MIL_PRE_NOTIFY_DT |
Date(10) |
DATE |
Prenotification Date
|
| 13 |
MIL_RANK_CHNG_STAT |
Character(4) |
VARCHAR2(4) NOT NULL |
Disposition Status
AMD=Amendment
CNA=Cancel by Administrator
CNC=Cancel by Command
NEW=New
Prompt Table:
MIL_TMPL_DEF_VW
Set Control Field: ACTION
|
| 14 |
MILITARY_SERVICE |
Character(8) |
VARCHAR2(8) NOT NULL |
Military Service
Prompt Table:
MIL_SERVICE_TBL
|
| 15 |
MIL_SVC_COMP_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Service Component
Prompt Table:
MIL_SVC_CMP_VW
|
| 16 |
MIL_CMP_CATEGORY |
Character(4) |
VARCHAR2(4) NOT NULL |
Component Category
Prompt Table:
MIL_CMP_CAT_VW
|
| 17 |
MIL_RANK |
Character(5) |
VARCHAR2(5) NOT NULL |
Military Rank
|
| 18 |
MIL_WORN_RANK |
Character(5) |
VARCHAR2(5) NOT NULL |
Worn Rank
Prompt Table:
MIL_WORN_RNK_VW
|
| 19 |
MIL_WORN_RNK_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Worn Rank Type
Prompt Table:
MIL_WRN_TYP_TBL
|
| 20 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 21 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 22 |
SAL_ADMIN_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Salary Administration Plan
|
| 23 |
GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Grade
|
| 24 |
JOB_FAMILY |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Family
|
| 25 |
JOB_FUNCTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Job Function Code
|
| 26 |
JOB_SUB_FUNC |
Character(3) |
VARCHAR2(3) NOT NULL |
Job sub Function
|
| 27 |
MIL_APPLIED_TO_JOB |
Character(1) |
VARCHAR2(1) NOT NULL |
Applied To Job Flag
|
| 28 |
WF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Workflow Status
A=Approved
C=Cancelled
D=Denied
E=Error. Contact Administrator.
F=Awaiting final approval
I=In Approval Process
M=Administrator is Processing
N=Not Available
P=Rework
S=Submitted
V=Data Saved
|
| 29 |
MIL_PRENOTIFY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to check if Prenotification has been sent to the Approvers
|
| 30 |
URL |
Character(254) |
VARCHAR2(254) NOT NULL |
Internet URL (Universal Resource Locator)
|
| 31 |
MIL_EARLY_PROM_DT |
Date(10) |
DATE |
Early Promotion Date
|