| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 4 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 5 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 6 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 7 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 8 |
GVT_LV_CLS_RULE_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Leave Class Rule ID
|
| 9 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 10 |
GVT_TRIGGER_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Leave Class Enrollment Trigger
C=Completed
E=Error
P=Pending
|
| 11 |
DESCR20 |
Character(20) |
VARCHAR2(20) NOT NULL |
Description
|
| 12 |
RANK |
Number(3,0) |
SMALLINT NOT NULL |
Rank
|
| 13 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
Prompt Table:
ACTION_TBL
|
| 14 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table:
GVT_ACTN_RSN_PR
|
| 15 |
GVT_NOA_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Nature of Action Code
Prompt Table:
GVT_NOAC_TBL
|
| 16 |
GVT_PAY_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Pay Plan
Prompt Table:
GVT_PAY_PLAN
|
| 17 |
GVT_WORK_SCHED |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Schedule
B=Baylor Plan
F=Full Time
G=Full Time Seasonal
I=Intermittent
J=Intermittent-Seasonal
P=Part Time
Q=Part-Time Seasonal
R=Part-Time Phased Retiree
S=Part-Time Job Sharer
T=Part-Time Seasonal Job Sharer
|
| 18 |
GVT_TYPE_OF_APPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Type of Appointment
10=Career (Competitive Svc Perm)
15=Career-Conditional (Comp Perm)
20=Nonpermanent (Comp NonPerm)
30=Schedule A (Except Svc Perm)
32=Schedule B (Except Svc Perm)
34=Schedule C (Except Svc Perm)
36=Executive (Except Svc Perm)
38=Other (Except Svc Perm)
40=Schedule A (Except NonPerm)
42=Schedule B (Except NonPerm)
44=Schedule C (Except NonPerm)
46=Executive (Except NonPerm)
48=Other (Except NonPerm)
50=Career (Senior Exec Perm)
55=Noncareer (Senior Exec Perm)
60=Limited Term (Senior Exec NPrm
65=Limited Emergency (SES NPerm)
|
| 19 |
GVT_TMP_NUM1 |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Temporary Num Storage 1
|