LM_NEW_LRN_HST

(SQL Table)
 Index Back

Activities and Programs

SQL work record used to hold activities and programs for popular learning pagelets. - History Table

# 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_LRNR_GROUP_ID Number(15,0) DECIMAL(15) NOT NULL Learner Group ID - Business Role/ Student Group ID
6 LM_ACT_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Holds the Activity or Program ID.
7 LM_ACT_PRG_CD Character(30) VARCHAR2(30) NOT NULL Holds activity or program code.
8 LM_ACT_PRG_STATUS Character(2) VARCHAR2(2) NOT NULL Activity or Program Status

Y/N Table Edit

Default Value: N

9 LM_ACT_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Holds activity or program long name.
10 LM_DM_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - the long name of a Delivery Method Type
11 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
12 LM_ACT_CD Character(30) VARCHAR2(30) NOT NULL Activity Code
13 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
14 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.
15 EFFDT_TO Date(10) DATE Effective Date To
16 LM_FIND_MORE_LINK Character(30) VARCHAR2(30) NOT NULL Find More link work field.
17 LM_ROW_NBR Number(6,0) INTEGER NOT NULL Holds a the row number in some learning pagelets.
18 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
19 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
20 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
21 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid