LM_PG_MGR_CRSE(SQL Table) |
Index Back |
---|---|
Learning Compliance RecordLearning Compliance Pivot Operator table |
# | 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_ID | Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
4 | LM_CI_ID | Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |
5 | LM_ACT_CD | Character(30) | VARCHAR2(30) NOT NULL |
Activity Code
Prompt Table: LM_PG_MGRCRS_VW |
6 | LM_LRN_TYPE_DESC | Character(15) | VARCHAR2(15) NOT NULL | Type |
7 | LM_ACT_NAME | Character(254) | VARCHAR2(254) NOT NULL | Learning |
8 | LM_CAT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Categories |
9 | LM_CURR_USER_FLG | Character(1) | VARCHAR2(1) NOT NULL | Current User AdHoc Learner Groups. |
10 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: LM_BU_VW |
11 | LM_ORGANIZATION_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Organization ID
Prompt Table: LM_ORG_VW |
12 | LM_LRNR_GROUP_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Learner Group ID - Business Role/ Student Group ID
Prompt Table: %EDITTABLE |
13 | LM_LE_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Learning Environment ID - System Generated number
Prompt Table: LM_CI_LE_VW |
14 | 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 |
15 | LM_ENRL_DT_FRM | Date(10) | DATE | Enrollment Date From |
16 | LM_ENRL_DT_TO | Date(10) | DATE | Enrollment Date To |