| # |
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 |
FROMDATE |
Date(10) |
DATE |
From Date
|
| 6 |
THRUDATE |
Date(10) |
DATE |
End Date
|
| 7 |
ACAD_ORG |
Character(10) |
VARCHAR2(10) NOT NULL |
Academic Organization
Prompt Table:
ACADORG_TREE_VW
|
| 8 |
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
|
| 9 |
SCHEDULE_PRINT |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Print
A=All
N=No
Y=Yes
Default Value: Y
|
| 10 |
SCHED_PRINT_INSTR |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Instructor in Schedule
A=All
N=No
Y=Yes
Default Value: Y
|
| 11 |
PRINT_SCHED_OUTPUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Output
A=Ascii Text File (CSV)
C=Crystal Reports
|
| 12 |
PRINT_CLASS_STAT_A |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Class Status - Active
Y/N Table Edit
Default Value: Y
|
| 13 |
PRINT_CLASS_STAT_C |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Class Status - Cancelled
Y/N Table Edit
Default Value: N
|
| 14 |
PRINT_CLASS_STAT_S |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Class Status - Stop Enrl
Y/N Table Edit
Default Value: Y
|
| 15 |
PRINT_CLASS_STAT_T |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Class Status - Tentative
Y/N Table Edit
Default Value: N
|
| 16 |
PRINT_MTG_PAT_INST |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Meeting Pattern/Instr
Y/N Table Edit
Default Value: Y
|
| 17 |
PRINT_GLOBAL_NOTES |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Global Notes
Y/N Table Edit
Default Value: Y
|
| 18 |
PRINT_CLASS_NOTES |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Class Notes
Y/N Table Edit
Default Value: Y
|
| 19 |
PRINT_COMBINE_SCTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Sections Combined
Y/N Table Edit
Default Value: N
|
| 20 |
PRINT_CLASS_CHRSTC |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Class Characteristics
Y/N Table Edit
Default Value: N
|
| 21 |
PRINT_NON_ENRL_NBR |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Class Nbr for Non-Enroll
Y/N Table Edit
Default Value: Y
|
| 22 |
PRINT_MTG_TOPIC |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Meeting Pattern Topic
Y/N Table Edit
Default Value: N
|
| 23 |
PRINT_OEE_DESIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Print OEE Designator
Y/N Table Edit
|
| 24 |
PRINT_RSRV_CAP |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Reserve Capacities
Y/N Table Edit
Default Value: N
|
| 25 |
ACAD_GROUP |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Group
Prompt Table:
ACAD_GROUP_TBL
|
| 26 |
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
|
| 27 |
PRINT_CRSE_EQUIV |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Course Equivalent
Y/N Table Edit
Default Value: Y
|
| 28 |
PRINT_CRSE_CMPNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Component Characteristic
Y/N Table Edit
Default Value: Y
|
| 29 |
PRINT_CRSE_TOPICS |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Course Topics
Y/N Table Edit
Default Value: N
|
| 30 |
PRINT_CRSE_ATTR |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Course Attributes
Y/N Table Edit
Default Value: Y
|
| 31 |
PRINT_RQ_GRP |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Require Group
Y/N Table Edit
Default Value: Y
|
| 32 |
FILE_PATH |
Character(127) |
VARCHAR2(127) NOT NULL |
Input/Output file path
|
| 33 |
COURSE_APPROVED |
Character(1) |
VARCHAR2(1) NOT NULL |
Course Approved
A=Approved
D=Denied
P=Pending
Default Value: A
|
| 34 |
CRSE_CATLG_PRINT |
Character(3) |
VARCHAR2(3) NOT NULL |
Catalog Print
A=All
N=No
Y=Yes
Default Value: Y
|
| 35 |
PRINT_CLASS_ATTR |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Class Attributes
Y/N Table Edit
Default Value: N
|
| 36 |
PRINT_REQ_DESIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Requirement Designation
Y/N Table Edit
Default Value: N
|
| 37 |
PRINT_REQ_DESIG2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Requirement Designation
Y/N Table Edit
Default Value: Y
|
| 38 |
PRINT_ENRL_LIMITS |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Class Enrollment Limits
Y/N Table Edit
Default Value: N
|
| 39 |
PRNT_BY_CAMPUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Print By Campus
Y/N Table Edit
Default Value: N
|
| 40 |
CAMPUS |
Character(5) |
VARCHAR2(5) NOT NULL |
Campus
Prompt Table:
CAMPUS_TBL
|
| 41 |
PRNT_BY_LOCATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Print By Location
Y/N Table Edit
Default Value: N
|
| 42 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
CAMPUS_LOC_VW
|
| 43 |
REPORT_REQUEST_NBR |
Character(9) |
VARCHAR2(9) NOT NULL |
Report Request Nbr
|
| 44 |
ROLL_FROM_TERM |
Character(4) |
VARCHAR2(4) NOT NULL |
Roll From Term
Prompt Table:
TERM_VAL_TBL
|
| 45 |
ROLL_TO_TERM |
Character(4) |
VARCHAR2(4) NOT NULL |
Roll To Term
Prompt Table:
TERM_VAL_TBL
|
| 46 |
REPORT_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Report Only
N=Final
Y=Review
Y/N Table Edit
Default Value: N
|
| 47 |
REPORT_TERM |
Character(4) |
VARCHAR2(4) NOT NULL |
Report Term
Prompt Table:
TERM_VAL_TBL
|
| 48 |
COPY_STD_ASSIGN |
Character(1) |
VARCHAR2(1) NOT NULL |
Copy Non-Course Assignments
|
| 49 |
BEGIN_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Begin with ID
Prompt Table:
PEOPLE_SRCH
|
| 50 |
END_EMPLID2 |
Character(11) |
VARCHAR2(11) NOT NULL |
End with ID
Prompt Table:
PEOPLE_SRCH
|
| 51 |
BEGIN_DT |
Date(10) |
DATE |
Begin Date
|
| 52 |
END_DT |
Date(10) |
DATE |
end date
Default Value: %date
|
| 53 |
UNPRINTED_REQUESTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag for selecting unprinted requests only.
Y/N Table Edit
Default Value: Y
|
| 54 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|