LM_ACT_PRG_WRK

(SQL Table)
Index Back

Activities and Programs

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
3 LM_ACT_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Holds the Activity or Program ID.
4 EFFDT Date(10) DATE Effective Date

Default Value: %date

5 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
6 LM_ACT_PRG_CD Character(30) VARCHAR2(30) NOT NULL Holds activity or program code.
7 LM_POP_LRNG_TYPE Character(2) VARCHAR2(2) NOT NULL Holds a type indicator of popular learning such as activity or program.
10=Activity
20=Program
8 LM_ACT_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Holds activity or program long name.
9 LM_DM_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - the long name of a Delivery Method Type
10 LM_ENRL_TOT Number(6,0) INTEGER NOT NULL Enrollment Total
11 LM_FIND_MORE_LINK Character(30) VARCHAR2(30) NOT NULL Find More link work field.
12 LM_FND_LRN_ACT_BTN Character(1) VARCHAR2(1) NOT NULL Find Learning Action Button
E=Enroll
L=Launch
P=Plan for Later
R=Register
S=Select
13 LM_ROW_NBR Number(6,0) INTEGER NOT NULL Holds a the row number in some learning pagelets.