LM_PGITEN_VW

(SQL View)
 Index Back

Program Reg Item Table

Program Reg Item Table

SELECT LM_PRG_REG_ID , LM_SCN_ID , LM_OBJ_ID , LM_OBJ_TYPE , LM_ENRLMT_ID , LM_PRG_ID , LM_PERSON_ID , LM_NSTPRG_REG_ID , LM_EQUIV_REG_ID , LM_EQUIV_OBJ_TYPE , LM_ROW_ADDED_DTTM , LM_ROW_ADDED_OPRID , LM_ROW_MAINT_DTTM , LM_ROW_MAINT_OPRID FROM PS_LM_PRG_ITEM_ENR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_PRG_REG_ID Number(10,0) DECIMAL(10) NOT NULL The Program Registration ID is a unique identifier for a learner's program enrollment.
2 LM_SCN_ID Number(10,0) DECIMAL(10) NOT NULL Section ID
3 LM_OBJ_ID Number(10,0) DECIMAL(10) NOT NULL Object ID - This value is relies upon the Object Type. The Object ID will either be the Catalog Item ID or the Learning Objective ID.
4 LM_OBJ_TYPE Character(3) VARCHAR2(3) NOT NULL Object Type
10=Catalog Item
20=Activity
30=Program
5 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID
6 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.
7 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
8 LM_NSTPRG_REG_ID Number(10,0) DECIMAL(10) NOT NULL The Program Registration ID is a unique identifier for a learner's program enrollment.
9 LM_EQUIV_REG_ID Number(10,0) DECIMAL(10) NOT NULL Equivalent Rehistration ID
10 LM_EQUIV_OBJ_TYPE Character(3) VARCHAR2(3) NOT NULL Equivalent Object Type
10=Course
20=Program
11 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
12 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
13 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
14 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid