RUN_CNTL_SRLMS(SQL Table) |
Index Back |
---|---|
LMS Run ControlLMS Extract File run control panel. |
# | 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 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
4 | STRM | Character(4) | VARCHAR2(4) NOT NULL |
Term
Default Value: OPR_DEF_TBL_CS.STRM Prompt Table: TERM_VAL_TBL |
5 | LMS_FILE_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
LMS extract file type: XML compliant, Blackboard specific, and WebCT specific
BKB=Blackboard CourseInfo 4 WCT=API Input (old WebCT format) XML=XML V1.1 (req to authenticate) Default Value: XML |
6 | LMS_DSRC_CODE | Character(10) | VARCHAR2(10) NOT NULL |
Datasource code
Prompt Table: LMS_DSRC_VW2 |
7 | LMS_TGT_CODE | Character(10) | VARCHAR2(10) NOT NULL |
LMS target codes
Prompt Table: LMS_TGT_VW2 |
8 | LMS_TYPE_CODE | Character(10) | VARCHAR2(10) NOT NULL |
LMS type codes
Prompt Table: LMS_TYPE_VW2 |
9 | LMS_EXTRACT_MODE | Character(1) | VARCHAR2(1) NOT NULL |
LMS Extract mode
S=Snapshot U=Update Default Value: S |
10 | LMS_LANGUAGE | Character(2) | VARCHAR2(2) NOT NULL | LMS run control properties object language attribute |
11 | LMS_SELCT_CRITERIA | Character(1) | VARCHAR2(1) NOT NULL |
LMS run control selection criteria verbiage
C=Class Number F=Filter N=None Default Value: N |
12 | SESSION_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Session
1=Regular Academic Session 10W=10 Week 12W=Twelve Week 4W1=Four Week - First 4W2=Four Week - Second 4W3=Four Week - Third 4W4=Four Week - Fourth 6W1=Six Week - First 6W2=Six Week - Second 8W1=Eight Week - First 8W2=Eight Week - Second A11=Medical Period 1, 4 Weeks A12=Medical Period 1, 8 Weeks A13=Medical Pd 1, 12 Weeks A21=Medical Period 2, 4 Weeks A22=Medical Period 2, 8 Weeks A23=Medical Period 2, 12 Week FYR=Full Year MIN=Mini Session OEE=Open Entry/Open Exit SM1=Semester 1 SM2=Semester 2 Prompt Table: SESSION_TBL |
13 | ACAD_CAREER | Character(4) | VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine Prompt Table: TERM_CAR_VW |
14 | CAMPUS | Character(5) | VARCHAR2(5) NOT NULL |
Campus
Prompt Table: CAMPUS_TBL |
15 | ACAD_GROUP | Character(5) | VARCHAR2(5) NOT NULL |
Academic Group
Prompt Table: ACAD_GROUP_TBL |
16 | SUBJECT | Character(8) | VARCHAR2(8) NOT NULL |
Subject Area
Prompt Table: SUBJECT_TBL |
17 | CATALOG_NBR | Character(10) | VARCHAR2(10) NOT NULL | Catalog Nbr |
18 | CLASS_NBR | Number(5,0) | INTEGER NOT NULL |
Class Nbr
Prompt Table: CLASS_TBL_VW |
19 | FILE_PATH | Character(127) | VARCHAR2(127) NOT NULL | Input/Output file path |
20 | LMS_COMBINE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
LMS combined output flag
Y/N Table Edit Default Value: N |
21 | LMS_COMBINE_FILE | Character(100) | VARCHAR2(100) NOT NULL | LMS combined output file |
22 | LMS_PEOPLE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
LMS people object file flag
Y/N Table Edit Default Value: N |
23 | LMS_PEOPLE_FILE | Character(100) | VARCHAR2(100) NOT NULL | LMS people object file name |
24 | LMS_CLASS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
LMS group object output flag
Y/N Table Edit Default Value: N |
25 | LMS_CLASS_FILE | Character(100) | VARCHAR2(100) NOT NULL | LMS group object output file |
26 | LMS_ENROLL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
LMS membership file flag
Y/N Table Edit Default Value: N |
27 | LMS_ENROLL_FILE | Character(100) | VARCHAR2(100) NOT NULL | LMS membership outptu file |
28 | LMS_GLOBAL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
LMS global file flag
Y/N Table Edit Default Value: N |
29 | LMS_GLOBAL_FILE | Character(100) | VARCHAR2(100) NOT NULL | LMS global file name |
30 | LMS_PROVIDER | Character(30) | VARCHAR2(30) NOT NULL |
Provider for Authentication
Prompt Table:
LMS_INT_SETUP
|