LN_DRVR_LIC_VW (SQL View)	Index Back
Driver's License View 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.

LN_DRVR_LIC_VW

(SQL View)

Driver's License View

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 from PS_DRIVERS_LIC

Parent record: HCR_PERSON_I

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BORR_EMPLID Character(11) VARCHAR2(11) NOT NULL Borrower ID

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

3 STATE Character(6) VARCHAR2(6) NOT NULL State

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BORR_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Borrower ID
2	DRIVERS_LIC_NBR	Character(20)	VARCHAR2(20) NOT NULL	Driver's License #
3	STATE	Character(6)	VARCHAR2(6) NOT NULL	State