LM_LRQ_CRIT_FRA (SQL Table)	Index Back
Learning Req Crit details Learning Request Criteria: To maintain the Training Plan Attributes and the history

LM_LRQ_CRIT_FRA

(SQL Table)

Learning Req Crit details

Learning Request Criteria: To maintain the Training Plan Attributes and the history

Related Language Record: LM_LRQCR_FR_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_LE_ID Number(10,0) DECIMAL(10) NOT NULL Learning Environment ID - System Generated number

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

3 LM_LRQ_ATTR_ID Number(3,0) SMALLINT NOT NULL Learning Request ID

4 LM_LRQ_ATTR_CODE Character(25) VARCHAR2(25) NOT NULL Criteria

5 LM_LRQ_ATTR_VALUE Character(50) VARCHAR2(50) NOT NULL Learning Request Criteria Value

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_LE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Environment ID - System Generated number
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	LM_LRQ_ATTR_ID	Number(3,0)	SMALLINT NOT NULL	Learning Request ID
4	LM_LRQ_ATTR_CODE	Character(25)	VARCHAR2(25) NOT NULL	Criteria
5	LM_LRQ_ATTR_VALUE	Character(50)	VARCHAR2(50) NOT NULL	Learning Request Criteria Value