LM_ACTCI_CLS_VW(SQL View) |
Index Back |
---|---|
Activity CI UI ViewActivity and Catalog Item View for Catalog User Interface |
SELECT A.LM_CI_ID , A.LM_ACT_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 ,%subrec(LM_PRICING_SBR,A) FROM PS_LM_ACT_CI_VW A WHERE LM_ACT_STATUS = '3' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | LM_CI_ID | Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |
2 | LM_ACT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
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_INT_PRICE | Number(19,3) | DECIMAL(18,3) NOT NULL | Internal Learner - Price |
46 | LM_EXT_PRICE | Number(19,3) | DECIMAL(18,3) NOT NULL | External Learner - Price |
47 | LM_TRNG_UT | Number(14,3) | DECIMAL(13,3) NOT NULL | Training Units - Price |
48 | LM_INT_DP_PRICE | Number(19,3) | DECIMAL(18,3) NOT NULL | Internal Learner - Drop Price |
49 | LM_EXT_DP_PRICE | Number(19,3) | DECIMAL(18,3) NOT NULL | External Learner - Drop Price |
50 | LM_DP_TRNG_UT | Number(14,3) | DECIMAL(13,3) NOT NULL | Drop Training Units |
51 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |