GVT_FGHR361_TAO

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 GVT_LV_CLS_RULE_ID Character(8) VARCHAR2(8) NOT NULL Leave Class Rule ID

3 GVT_LVCLSCRIT_TYPE Character(1) VARCHAR2(1) NOT NULL Leave Class Rule Criteria Type
H=Hire / ReHire
L=Leave Program Status
P=Non-Hire PAR actions

4 EFFDT Date(10) DATE Effective Date
Default Value: %date

5 ACTION Character(3) VARCHAR2(3) NOT NULL Action
Prompt Table: GVT_ACTN_PRMPT

6 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
Prompt Table: GVT_ACTN_RSN_PR

7 GVT_NOA_CODE Character(3) VARCHAR2(3) NOT NULL Nature of Action Code
Prompt Table: GVT_NOAC_TBL

8 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan
Prompt Table: GVT_PAY_PLAN

9 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

10 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)

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	GVT_LV_CLS_RULE_ID	Character(8)	VARCHAR2(8) NOT NULL	Leave Class Rule ID
3	GVT_LVCLSCRIT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Leave Class Rule Criteria Type H=Hire / ReHire L=Leave Program Status P=Non-Hire PAR actions
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: GVT_ACTN_PRMPT
6	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code Prompt Table: GVT_ACTN_RSN_PR
7	GVT_NOA_CODE	Character(3)	VARCHAR2(3) NOT NULL	Nature of Action Code Prompt Table: GVT_NOAC_TBL
8	GVT_PAY_PLAN	Character(2)	VARCHAR2(2) NOT NULL	Pay Plan Prompt Table: GVT_PAY_PLAN
9	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
10	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)