LM_ADHC_LE_TBL (SQL Table)	Index Back
Adhoc LE Table Adhoc LE Table

LM_ADHC_LE_TBL

(SQL Table)

Adhoc LE Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_ADHC_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Id
Default Value: 0

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

3 LM_LE_ID Number(10,0) DECIMAL(10) NOT NULL Learning Environment ID - System Generated number
Default Value: 0
Prompt Table: LM_ADHC_LE_VW1

4 LM_END_EFFDT Date(10) DATE The end effective date, automatically maintained, there's a doc on how this works, so read it

5 LM_PRM_LE Character(2) VARCHAR2(2) NOT NULL Primary Learning Environment - This is a Yes/No field that signifies if the learning environment on the current row is the primary learning environment for the accompanying object (i.e. Catalog Item, Category)
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_ADHC_ID	Number(10,0)	DECIMAL(10) NOT NULL	Adhoc Id Default Value: 0
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	LM_LE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Environment ID - System Generated number Default Value: 0 Prompt Table: LM_ADHC_LE_VW1
4	LM_END_EFFDT	Date(10)	DATE	The end effective date, automatically maintained, there's a doc on how this works, so read it
5	LM_PRM_LE	Character(2)	VARCHAR2(2) NOT NULL	Primary Learning Environment - This is a Yes/No field that signifies if the learning environment on the current row is the primary learning environment for the accompanying object (i.e. Catalog Item, Category) Y/N Table Edit Default Value: N