LM_ACT_LG_UI_VW(SQL View) |
Index Back |
|---|---|
Activity CI UI ViewActivity and Catalog Item View for Catalog User Interface |
| SELECT A.LM_ACT_ID , A.LM_CI_ID , A.LM_ACT_CD , A.LM_ACT_STATUS , A.LM_CS_LONG_NM , A.LM_CS_DESCR , A.LM_DMTHD_TYPE_ID , A.LM_DMTHD_ID , A.LM_DM_LONG_NM , A.LANGUAGE_CD , A.LM_START_DT , A.LM_END_DT , A.LM_DISP_DATES , A.LM_DISP_START_DT , A.LM_DISP_END_DT , A.LM_MIN_ENRLMT , A.LM_MAX_ENRLMT , A.LM_NFRC_MAX_ENRLMT , A.LM_ENRL_TOT , A.LM_ENABLE_WTLST , A.LM_WTLST_CAP , A.LM_WTLST_TOT , A.LM_APRVL_TYPE_REQ , A.LM_APRVL_REQ_EXT , A.LM_ENRLMT_ADMIN_ID , A.LM_NFRC_PRQ , A.LM_AUTO_ATND , A.LM_AUTO_CMPL_DURN , A.LM_AUTO_ASGN_OBJV , A.LM_CEU , A.LM_LST_ENRL_DAYS , A.LM_LST_ENRL_DT , A.LM_LST_DROP_DAYS , A.LM_LST_DROP_DT , A.LM_RMNDR_DAYS , A.LM_RMNDR_DT , A.LM_RMNDR_ID , A.LM_ACT_OWNER_ID , A.LM_OVERBOOK_PCT , A.LM_MIN_ENRL_DAYS , A.LM_LRN_PD_DAYS , A.LM_WRN_PD_DAYS , A.LM_INSTR_ID , A.LM_RESTRICT_TO_PRG , B.LM_LRNR_GROUP_ID ,%subrec(LM_PRICING_SBR,A) FROM PS_LM_ACT_CI_VW A , PS_LM_ACT_SEC B WHERE A.LM_ACT_ID = B.LM_ACT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_ACT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
| 2 | LM_CI_ID | Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |
| 3 | LM_ACT_CD | Character(30) | VARCHAR2(30) NOT NULL | Activity Code |
| 4 | LM_ACT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Activity Status
1=Active 2=Inactive 3=Closed 4=Pending 5=Concluded |
| 5 | LM_CS_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Long Name - Describes the long name of an object |
| 6 | LM_CS_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Description - Describes an object with further detail |
| 7 | LM_DMTHD_TYPE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Delivery Method Type ID - This is a unique identifier for each delivery method type |
| 8 | LM_DMTHD_ID | Number(10,0) | DECIMAL(10) NOT NULL | Delivery Method ID - This is a system generated number used to uniquely identify each new Delivery Method |
| 9 | LM_DM_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Long Name - the long name of a Delivery Method Type |
| 10 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 11 | LM_START_DT | Date(10) | DATE | Start Date |
| 12 | LM_END_DT | Date(10) | DATE | End Date |
| 13 | LM_DISP_DATES | Character(1) | VARCHAR2(1) NOT NULL | Use Display Dates |
| 14 | LM_DISP_START_DT | Date(10) | DATE | Display Start Date |
| 15 | LM_DISP_END_DT | Date(10) | DATE | Display End Date |
| 16 | LM_MIN_ENRLMT | Number(10,0) | DECIMAL(10) NOT NULL | Minimum Enrollment - Minimum number of students that are required to be in an activity in order for an activity to be held. |
| 17 | LM_MAX_ENRLMT | Number(10,0) | DECIMAL(10) NOT NULL | Maximum Enrollment - Maximum number of students that may be enrolled in an activity. |
| 18 | LM_NFRC_MAX_ENRLMT | Character(1) | VARCHAR2(1) NOT NULL | Enforce Maximum Enrollment - Enforces the amount indicated as the Maximum Enrollment for an activity. |
| 19 | LM_ENRL_TOT | Number(6,0) | INTEGER NOT NULL | Enrollment Total |
| 20 | LM_ENABLE_WTLST | Character(3) | VARCHAR2(3) NOT NULL | Enable Waitlist - A Yes/No field. Selecting the checkbox indicates that learners may be waitlisted for this activity. |
| 21 | LM_WTLST_CAP | Number(10,0) | DECIMAL(10) NOT NULL | Waitlist Capacity - Maximum number of students that may enroll and be placed on the waitlist. |
| 22 | LM_WTLST_TOT | Number(4,0) | SMALLINT NOT NULL | Stores the total number of learners currently on the waitlist |
| 23 | LM_APRVL_TYPE_REQ | Character(30) | VARCHAR2(30) NOT NULL |
Specifies the approval type required to take a given course, refer to the translate values
10=None 20=Standard |
| 24 | LM_APRVL_REQ_EXT | Character(3) | VARCHAR2(3) NOT NULL |
Enrollment Admin Approval Required for Non-Employees
10=None 40=Learning Admin 60=Payment |
| 25 | LM_ENRLMT_ADMIN_ID | Number(15,0) | DECIMAL(15) NOT NULL | Enrollment Administrator ID |
| 26 | LM_NFRC_PRQ | Character(1) | VARCHAR2(1) NOT NULL | Enforce Prerequisites |
| 27 | LM_AUTO_ATND | Character(1) | VARCHAR2(1) NOT NULL | Auto Mark Attendance - Indicates Attendance will automatically be marked at the completion of the activity |
| 28 | LM_AUTO_CMPL_DURN | Number(3,0) | SMALLINT NOT NULL | Auto Completion Duration - Provides the number of days after the conclusion of an activity that triggers the Auto Mark Attendance process to run. |
| 29 | LM_AUTO_ASGN_OBJV | Character(1) | VARCHAR2(1) NOT NULL | Auto Assign Objectives |
| 30 | LM_CEU | Number(8,2) | DECIMAL(7,2) NOT NULL | Continuing Education Units |
| 31 | LM_LST_ENRL_DAYS | Number(3,0) | SMALLINT NOT NULL | Last Enroll Days |
| 32 | LM_LST_ENRL_DT | Date(10) | DATE | Last Enroll Date |
| 33 | LM_LST_DROP_DAYS | Number(3,0) | SMALLINT NOT NULL | Last Drop Days |
| 34 | LM_LST_DROP_DT | Date(10) | DATE | Last Drop Date |
| 35 | LM_RMNDR_DAYS | Number(3,0) | SMALLINT NOT NULL | Reminder Days |
| 36 | LM_RMNDR_DT | Date(10) | DATE | Reminder Date |
| 37 | LM_RMNDR_ID | Character(30) | VARCHAR2(30) NOT NULL | Reminder ID |
| 38 | LM_ACT_OWNER_ID | Number(15,0) | DECIMAL(15) NOT NULL | Activity Owner |
| 39 | LM_OVERBOOK_PCT | Number(3,0) | SMALLINT NOT NULL | Overbook Percent |
| 40 | LM_MIN_ENRL_DAYS | Number(3,0) | SMALLINT NOT NULL | Minimum Enrollment Days -- Days prior to the start date that the min enrollment should be met |
| 41 | LM_LRN_PD_DAYS | Number(3,0) | SMALLINT NOT NULL | Learning Period Days -- Number of days student can access online content. |
| 42 | LM_WRN_PD_DAYS | Number(3,0) | SMALLINT NOT NULL | Warning Period Days |
| 43 | LM_INSTR_ID | Number(15,0) | DECIMAL(15) NOT NULL | Instructor ID |
| 44 | LM_RESTRICT_TO_PRG | Character(1) | VARCHAR2(1) NOT NULL | Restrict to Programs |
| 45 | LM_LRNR_GROUP_ID | Number(15,0) | DECIMAL(15) NOT NULL | Learner Group ID - Business Role/ Student Group ID |
| 46 | LM_INT_PRICE | Number(19,3) | DECIMAL(18,3) NOT NULL | Internal Learner - Price |
| 47 | LM_EXT_PRICE | Number(19,3) | DECIMAL(18,3) NOT NULL | External Learner - Price |
| 48 | LM_TRNG_UT | Number(14,3) | DECIMAL(13,3) NOT NULL | Training Units - Price |
| 49 | LM_INT_DP_PRICE | Number(19,3) | DECIMAL(18,3) NOT NULL | Internal Learner - Drop Price |
| 50 | LM_EXT_DP_PRICE | Number(19,3) | DECIMAL(18,3) NOT NULL | External Learner - Drop Price |
| 51 | LM_DP_TRNG_UT | Number(14,3) | DECIMAL(13,3) NOT NULL | Drop Training Units |
| 52 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |