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

HCR_DRVRS_LIC_I

(SQL View)

Driver's License

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 A.EMPLID , A.DRIVERS_LIC_NBR , A.COUNTRY , A.STATE FROM PS_DRIVERS_LIC A

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: PERSON

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

3 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	DRIVERS_LIC_NBR	Character(20)	VARCHAR2(20) NOT NULL	Driver's License #
3	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
4	STATE	Character(6)	VARCHAR2(6) NOT NULL	State