LM_PGMGCRS_HST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
5	LM_ACT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Activity ID
6	LM_CI_ID	Number(10,0)	DECIMAL(10) NOT NULL	Catalog Item ID - System Generated ID Number associated with each Catalog Item
7	LM_ACT_CD	Character(30)	VARCHAR2(30) NOT NULL	Activity Code Prompt Table: LM_PG_MGRCRS_VW
8	LM_LRN_TYPE_DESC	Character(15)	VARCHAR2(15) NOT NULL	Type
9	LM_ACT_NAME	Character(254)	VARCHAR2(254) NOT NULL	Learning
10	LM_CAT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Categories
11	LM_CURR_USER_FLG	Character(1)	VARCHAR2(1) NOT NULL	Current User AdHoc Learner Groups.
12	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: LM_BU_VW
13	LM_ORGANIZATION_ID	Number(15,0)	DECIMAL(15) NOT NULL	Organization ID Prompt Table: LM_ORG_VW
14	LM_LRNR_GROUP_ID	Number(15,0)	DECIMAL(15) NOT NULL	Learner Group ID - Business Role/ Student Group ID Prompt Table: %EDITTABLE
15	LM_LE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Environment ID - System Generated number Prompt Table: LM_CI_LE_VW
16	LM_STTS	Character(4)	VARCHAR2(4) NOT NULL	Enrollment Status CANC=Dropped COMP=Completed DECL=Denied ENRL=Enrolled INCO=Not Completed INPO=In-Progress MACT=Moved to New Activity NOTS=Not Started PEAP=Pending Approval PEPA=Pending Payment PLAN=Planned PPYA=Payment Approval RQST=Learning Request WAIV=Waived WTLT=Waitlisted
17	LM_ENRL_DT_FRM	Date(10)	DATE	Enrollment Date From
18	LM_ENRL_DT_TO	Date(10)	DATE	Enrollment Date To