| # |
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 Record
Default Value: 0
|
| 3 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 4 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 5 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
Prompt Table:
RANK_CHNG_STAT
|
| 6 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table:
ACTN_REASON_TBL
Set Control Field: ACTION
|
| 7 |
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
|
| 8 |
MIL_RANK_CHNG_DT |
Date(10) |
DATE NOT NULL |
Disposition Status Date
Default Value: %date
|
| 9 |
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
Default Value: V
|
| 10 |
MIL_RANK_APPL_DT |
Date(10) |
DATE |
Application Date
|
| 11 |
MIL_EARLY_REVW_DT |
Date(10) |
DATE |
Earliest Review Date value for Military Approvals is calculated and stored in this field
|
| 12 |
MIL_PROMOTION_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Promotion Sequence
|
| 13 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
BUSUNIT_HR_VW
|
| 14 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPT_TBL
|
| 15 |
MIL_RESP_CAR_MGR |
Character(4) |
VARCHAR2(4) NOT NULL |
Responsible Career Manager
POSN=Position Number
ROLE=Role
Default Value: POSN
|
| 16 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
Prompt Table:
POSN_DATA_VW
|
| 17 |
ROLENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table:
PSROLEDEFN_VW
|
| 18 |
MIL_RANK |
Character(5) |
VARCHAR2(5) NOT NULL |
Military Rank
Prompt Table:
MIL_RANK_TBL
|
| 19 |
MIL_WORN_RANK |
Character(5) |
VARCHAR2(5) NOT NULL |
Worn Rank
Prompt Table:
MIL_WORN_RNK_VW
|
| 20 |
MIL_WORN_RNK_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Worn Rank Type
Prompt Table:
MIL_WRN_TYP_TBL
|
| 21 |
SAL_ADMIN_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Salary Administration Plan
Prompt Table:
%EDITTABLE7
|
| 22 |
GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Grade
Prompt Table:
%EDITTABLE8
|
| 23 |
JOB_FAMILY |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Family
Prompt Table:
JOB_FAMILY_TBL
|
| 24 |
JOB_FUNCTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Job Function Code
Prompt Table:
JOBFUNCTION_TBL
|
| 25 |
JOB_SUB_FUNC |
Character(3) |
VARCHAR2(3) NOT NULL |
Job sub Function
Prompt Table:
JOB_SUB_FNC_VW
|
| 26 |
OLD_MIL_RANK |
Character(5) |
VARCHAR2(5) NOT NULL |
Military Rank
|
| 27 |
OLD_RANK_ENTRY_DT |
Date(10) |
DATE |
The employee's date when the new rank was given
|
| 28 |
OLD_MIL_WORN_RANK |
Character(5) |
VARCHAR2(5) NOT NULL |
Worn Rank
|
| 29 |
OLD_WORN_RNK_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Worn Rank Type
|
| 30 |
OLD_SAL_ADMIN_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
This field is used to check for the Sal Admin Plan that the Person was holding before the current row in Job
|
| 31 |
OLD_GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
This field is used to check for the Grade that the Person was holding before the current row in Job
|
| 32 |
OLD_JOB_FAMILY |
Character(6) |
VARCHAR2(6) NOT NULL |
This field is used to check for the Job family that the Person was holding before the current row in Job
|
| 33 |
OLD_JOB_FUNCTION |
Character(3) |
VARCHAR2(3) NOT NULL |
This field is used to check for the Job Function that the Person was holding before the current row in Job
|
| 34 |
OLD_JOB_SUB_FUNC |
Character(3) |
VARCHAR2(3) NOT NULL |
Job sub Function
|
| 35 |
MIL_APPROVAL_START |
Date(10) |
DATE |
Approval Start Date
Default Value: %date
|
| 36 |
MIL_TEMPLATE_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Military Rank Template unique identifier
Prompt Table:
MIL_TMPL_DEFN
|
| 37 |
MIL_PRE_NOTIFY_DT |
Date(10) |
DATE |
Prenotification Date
|
| 38 |
MIL_APPLY_JOB_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Row to Job Switch
|
| 39 |
MIL_APPLIED_TO_JOB |
Character(1) |
VARCHAR2(1) NOT NULL |
Applied To Job Flag
Y/N Table Edit
Default Value: N
|
| 40 |
MIL_EARLY_REVW_SW |
Character(2) |
VARCHAR2(2) NOT NULL |
Early Review Switch
JE=JOB.EFFDT + Number of Weeks
NA=No Affect
SC=Special Calculation Routine
|
| 41 |
MIL_EARLY_REVW_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Number of Weeks
|
| 42 |
MIL_EARLY_PROM_DT |
Date(10) |
DATE |
Early Promotion Date
|
| 43 |
COMMENTS |
Long Character |
CLOB |
Comment
|
| 44 |
MIL_DENY_REASON |
Character(1) |
VARCHAR2(1) NOT NULL |
Denial Reasons to be recorded if a particular Military Rank Change Transaction has been denied.
A=Change in Medical Condition
B=Legal Action
C=Not Applicable
Default Value: C
|
| 45 |
URL |
Character(254) |
VARCHAR2(254) NOT NULL |
Internet URL (Universal Resource Locator)
|
| 46 |
MIL_PRENOTIFY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to check if Prenotification has been sent to the Approvers
Y/N Table Edit
Default Value: N
|