LM_PGITEN_HSTVW

(SQL View)
 Index Back

Program Reg Item Table

Program Reg Item Table

SELECT PSARCH_ID , PSARCH_BATCHNUM , 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_PGITMENR_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 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.
4 LM_SCN_ID Number(10,0) DECIMAL(10) NOT NULL Section ID
5 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.
6 LM_OBJ_TYPE Character(3) VARCHAR2(3) NOT NULL Object Type
10=Catalog Item
20=Activity
30=Program
7 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID
8 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.
9 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
10 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.
11 LM_EQUIV_REG_ID Number(10,0) DECIMAL(10) NOT NULL Equivalent Rehistration ID
12 LM_EQUIV_OBJ_TYPE Character(3) VARCHAR2(3) NOT NULL Equivalent Object Type
10=Course
20=Program
13 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
14 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
15 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
16 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid