COMP_PROP (SQL Table)	Index Back
Company Prop Assigned to EE Use COMP_PROP to identify the employee a piece of company property, other than a company credit card, is issued to. To identify which employee a company credit card is issued to, use the COMP_CR_CRD record.

COMP_PROP

(SQL Table)

Company Prop Assigned to EE

Use COMP_PROP to identify the employee a piece of company property, other than a company credit card, is issued to. To identify which employee a company credit card is issued to, use the COMP_CR_CRD record.

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 PROPERTY_ID Character(10) VARCHAR2(10) NOT NULL Property Code
Prompt Table: COMP_PROP_TBL

3 DT_ISSUED Date(10) DATE NOT NULL Issue Date
Default Value: %date

4 DT_RETURNED Date(10) DATE Date Returned

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	PROPERTY_ID	Character(10)	VARCHAR2(10) NOT NULL	Property Code Prompt Table: COMP_PROP_TBL
3	DT_ISSUED	Date(10)	DATE NOT NULL	Issue Date Default Value: %date
4	DT_RETURNED	Date(10)	DATE	Date Returned