SCC_DLICTYP_H

(SQL View)
 Index Back

Driver License Types

Campus Solutions hollow view for the core DRIVER_LTYP table. Data is actually sourced from the Service Oriented Architecture.

SELECT ' ' , ' ' , ' ' FROM %Table(INSTALLATION_SA)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 DRIVERS_LIC_NBR Character(20) VARCHAR2(20) NOT NULL Driver's License #
3 LICENSE_TYPE Character(4) VARCHAR2(4) NOT NULL License Type
C=Car
CH=Chauffeur
M=Motorcycle
T=Truck

Prompt Table: DRIVER_LTYP_TBL