GVT_LV_CLS_RULE

(SQL Table)
 Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GVT_LV_CLS_RULE_ID Character(8) VARCHAR2(8) NOT NULL Leave Class Rule ID
2 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
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
7 ACTION Character(3) VARCHAR2(3) NOT NULL Action

Prompt Table: ACTION_TBL

8 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

Prompt Table: ACTN_REASON_TBL

9 GVT_NOA_CODE Character(3) VARCHAR2(3) NOT NULL Nature of Action Code

Prompt Table: GVT_NOAC_TBL

10 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan

Prompt Table: GVT_PAY_PLAN

11 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
12 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)
13 GVT_LEAVE_XFR_PRGM Character(1) VARCHAR2(1) NOT NULL Leave Transfer Program
B=Bank
E=Emergency
V=Voluntary