LM_CI_ALL_VW (SQL View)	Index Back
Catalog Item View Returns all the fields in the Catalog Item Table

LM_CI_ALL_VW

(SQL View)

Catalog Item View

Returns all the fields in the Catalog Item Table

SELECT LM_CI_ID , EFFDT , LM_END_EFFDT , LM_CI_STATUS , LM_CS_LONG_NM , LM_CS_SHRT_NM , LM_CS_DESCR , LM_CI_ABST , LM_CRSE_CODE , LM_APRVL_TYPE_REQ , LM_EXTRNL_OFRNG , LM_APRVL_REQ_EXT , LM_EXTRNL_ID , LM_EXTRNL_INFO , LM_VENDOR_ID , LM_VNDR_CRSE_CD , LM_OWNER_ID , %subrec(LM_CI_FRA_SBR, PS_LM_CI_TBL) , LM_FLAT_COST , CURRENCY_CD FROM PS_LM_CI_TBL

Related Language Record: LM_CI_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item

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

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

4 LM_CI_STATUS Character(3) VARCHAR2(3) NOT NULL Catalog Item Status - A drop down list with values indicating the current status of the learning activity.
10=Active
20=Inactive
40=Pending

5 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object

6 LM_CS_SHRT_NM Character(10) VARCHAR2(10) NOT NULL Short Name - Describes the short name of an object

7 LM_CS_DESCR Character(254) VARCHAR2(254) NOT NULL Description - Describes an object with further detail

8 LM_CI_ABST Long Character CLOB Catalog Item Abstract - In addition to the description this field allows for a very long text field for an abstract of the learning activity.

9 LM_CRSE_CODE Character(30) VARCHAR2(30) NOT NULL Course Code - User defined Code

10 LM_APRVL_TYPE_REQ Character(30) VARCHAR2(30) NOT NULL Specifies the approval type required to take a given course, refer to the translate values
10=None
20=Standard

11 LM_EXTRNL_OFRNG Character(3) VARCHAR2(3) NOT NULL Internal/External Offering - A checkbox allowing the user to select whether the course is Internal or External.
10=Internal
20=External

12 LM_APRVL_REQ_EXT Character(3) VARCHAR2(3) NOT NULL Enrollment Admin Approval Required for Non-Employees
10=None
40=Learning Admin
60=Payment

13 LM_EXTRNL_ID Number(10,0) DECIMAL(10) NOT NULL External ID - This field comes in from an external vendor and/or user and is user defined

14 LM_EXTRNL_INFO Character(30) VARCHAR2(30) NOT NULL External Information - This field is populated by external user/vendor and is user defined.

15 LM_VENDOR_ID Number(15,0) DECIMAL(15) NOT NULL Vendor ID

16 LM_VNDR_CRSE_CD Character(30) VARCHAR2(30) NOT NULL Vendor Course Code - This is a user defined Code.

17 LM_OWNER_ID Number(15,0) DECIMAL(15) NOT NULL Owner ID

18 LM_VENDOR_PROD_ID Number(15,0) DECIMAL(15) NOT NULL Vendor Product ID
Prompt Table: LM_VENDOR_PROD

19 LM_DIFELIGIBLE_FLG Character(1) VARCHAR2(1) NOT NULL Eligible to DIF
Y/N Table Edit
Default Value: N

20 LM_TRAINING_CLASS Character(10) VARCHAR2(10) NOT NULL Training Class
Default Value: 9
Prompt Table: LM_TCLASS_VW

21 LM_FLAT_COST Number(19,3) DECIMAL(18,3) NOT NULL Flat cost

22 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_CI_ID	Number(10,0)	DECIMAL(10) NOT NULL	Catalog Item ID - System Generated ID Number associated with each Catalog Item
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	LM_END_EFFDT	Date(10)	DATE	The end effective date, automatically maintained, there's a doc on how this works, so read it
4	LM_CI_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Catalog Item Status - A drop down list with values indicating the current status of the learning activity. 10=Active 20=Inactive 40=Pending
5	LM_CS_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Long Name - Describes the long name of an object
6	LM_CS_SHRT_NM	Character(10)	VARCHAR2(10) NOT NULL	Short Name - Describes the short name of an object
7	LM_CS_DESCR	Character(254)	VARCHAR2(254) NOT NULL	Description - Describes an object with further detail
8	LM_CI_ABST	Long Character	CLOB	Catalog Item Abstract - In addition to the description this field allows for a very long text field for an abstract of the learning activity.
9	LM_CRSE_CODE	Character(30)	VARCHAR2(30) NOT NULL	Course Code - User defined Code
10	LM_APRVL_TYPE_REQ	Character(30)	VARCHAR2(30) NOT NULL	Specifies the approval type required to take a given course, refer to the translate values 10=None 20=Standard
11	LM_EXTRNL_OFRNG	Character(3)	VARCHAR2(3) NOT NULL	Internal/External Offering - A checkbox allowing the user to select whether the course is Internal or External. 10=Internal 20=External
12	LM_APRVL_REQ_EXT	Character(3)	VARCHAR2(3) NOT NULL	Enrollment Admin Approval Required for Non-Employees 10=None 40=Learning Admin 60=Payment
13	LM_EXTRNL_ID	Number(10,0)	DECIMAL(10) NOT NULL	External ID - This field comes in from an external vendor and/or user and is user defined
14	LM_EXTRNL_INFO	Character(30)	VARCHAR2(30) NOT NULL	External Information - This field is populated by external user/vendor and is user defined.
15	LM_VENDOR_ID	Number(15,0)	DECIMAL(15) NOT NULL	Vendor ID
16	LM_VNDR_CRSE_CD	Character(30)	VARCHAR2(30) NOT NULL	Vendor Course Code - This is a user defined Code.
17	LM_OWNER_ID	Number(15,0)	DECIMAL(15) NOT NULL	Owner ID
18	LM_VENDOR_PROD_ID	Number(15,0)	DECIMAL(15) NOT NULL	Vendor Product ID Prompt Table: LM_VENDOR_PROD
19	LM_DIFELIGIBLE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Eligible to DIF Y/N Table Edit Default Value: N
20	LM_TRAINING_CLASS	Character(10)	VARCHAR2(10) NOT NULL	Training Class Default Value: 9 Prompt Table: LM_TCLASS_VW
21	LM_FLAT_COST	Number(19,3)	DECIMAL(18,3) NOT NULL	Flat cost
22	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code