ISIR_DRVLIC2_VW (SQL View)	Index Back
Driver's License on ISIR Use DRIVERS_LIC to record information about an employee's driver's licenses. You can create multiple DRIVERS_LIC records for an employee if they have more than one license.

ISIR_DRVLIC2_VW

(SQL View)

Driver's License on ISIR

Use DRIVERS_LIC to record information about an employee's driver's licenses. You can create multiple DRIVERS_LIC records for an employee if they have more than one license.

SELECT Emplid ,DRIVERS_LIC_NBR ,STATE ,COUNTRY FROM PS_DRIVERS_LIC

Parent record: PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PEOPLE_SRCH

2 DRIVERS_LIC_NBR Character(20) VARCHAR2(20) NOT NULL Driver's License #

3 DRIV_LIC_STATE Character(6) VARCHAR2(6) NOT NULL Issuing State

4 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Default Value: INSTALLATION.COUNTRY
Prompt Table: COUNTRY_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
2	DRIVERS_LIC_NBR	Character(20)	VARCHAR2(20) NOT NULL	Driver's License #
3	DRIV_LIC_STATE	Character(6)	VARCHAR2(6) NOT NULL	Issuing State
4	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Default Value: INSTALLATION.COUNTRY Prompt Table: COUNTRY_TBL