GVT_DISP_OFFNS (SQL Table)	Index Back
Disciplinary Offense Numbers GVT: Use GVT_DISP_OFFNS to identify the number of offenses that can apply to a particular disciplinary problem. This is a parent table for GVT_RECMND_ACTNS which then defines the recommended actions for a particular disciplinary problem based on the number of offenses.

GVT_DISP_OFFNS

(SQL Table)

Disciplinary Offense Numbers

GVT: Use GVT_DISP_OFFNS to identify the number of offenses that can apply to a particular disciplinary problem. This is a parent table for GVT_RECMND_ACTNS which then defines the recommended actions for a particular disciplinary problem based on the number of offenses.

Parent record: DISCIP_TYPE_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DISCIPLINARY_TYPE Character(3) VARCHAR2(3) NOT NULL Disciplinary Type
Prompt Table: DISCIP_TYPE_TBL

2 EFFDT Date(10) DATE NOT NULL Effective Date

3 GVT_OFFENSE_NR Character(1) VARCHAR2(1) NOT NULL Disciplinary Offense Number
1=1st Offense
2=2nd Offense
3=3rd Offense
4=4th Offense
5=5th Offense

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DISCIPLINARY_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Disciplinary Type Prompt Table: DISCIP_TYPE_TBL
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date
3	GVT_OFFENSE_NR	Character(1)	VARCHAR2(1) NOT NULL	Disciplinary Offense Number 1=1st Offense 2=2nd Offense 3=3rd Offense 4=4th Offense 5=5th Offense