University Course Export

Exports Course Details.

PrismCore Export_Univ_Course Table Names

(Use this for interfaces that bypass WPConsole and go directly to prism_trn)

Note: The export files for Univ Course Export will only be created when running the “Univ_Course_Export” in the WPConsole interface, there is no way to do this through PrismCore Admin.

Note: PRISM export is not supported.

Column	Data Type	Length	Description

Column	Data Type	Length	Description
hIdx	INT	4	Primary Key
TermName	VARCHAR	10	Term Name
TermDesc	VARCHAR	80	Term Description
DeptName	VARCHAR	20	Department Name
CourseName	VARCHAR	20	Course Name
CourseDesc	VARCHAR	80	Course Description
CourseCmnt	VARCHAR	80	Course Comment
CourseSection	VARCHAR	10	Course Section
SectionID	VARCHAR	20	SectionID
SectionCmnt	VARCHAR	80	Section Comment
Instructor	VARCHAR	40	Instructor Name
CourseItmReqDate	DATETIME	8	Course Request Date
ReqType	VARCHAR	30	Request Type
ReqQty	INT	4	Request Quantity
EnrollEsti	INT	4	Estimated Enrollment
EnrollActu	INT	4	Actual Enrollment
BookAuthor	VARCHAR	45	Author
BookTitle	VARCHAR	128	Title/Description
BookISBN	VARCHAR	30	ISBN/Catalog Number
BookEdition	VARCHAR	20	Edition
BookBinding	VARCHAR	20	Binding
BookCopyright	VARCHAR	2	Copyright Year
VendorCode	VARCHAR	10	Vendor Code
VendorName	VARCHAR	50	Vendor Name
SKUnew	INT	4	SKU of new item
SKUused	INT	4	SKU of used item
SKULinked	VARCHAR	1	‘C’ = Child, ‘P’ = Parent, ‘’ = Neither
SKUParent	INT	4	SKU of parent item
BookStatus	VARCHAR	15	Book Status
BookStatusDate	DATETIME	8	Book Status
ItemComment	VARCHAR	25	Item Comment
AdoptStatus	TINYINT	1	Adoption Status
NewOnly	TINYINT	1	New Only Flag
RetailNew	MONEY	8	New Retail Price
RetailUsed	MONEY	8	Used Retail Price
RentalNew	MONEY	8	New Rental Price
RentalUsed	MONEY	8	Used Rental Price
SOHNew	INT	4	New Stock On Hand
SOHUsed	INT	4	Used Stock On Hand
OnOrderNew	INT	4	New On Order and Proposed On Order
OnOrderUsed	INT	4	Used On Order and Proposed On Order
tm_stamp	TIMESTAMP	8	Timestamp

ASCII Delimited Format

TermName	CHAR	10
TermDesc	CHAR	80
DeptName	CHAR	20
CourseName	CHAR	20
CourseDesc	CHAR	80
CourseCmnt	CHAR	80
CourseSection	CHAR	10
SectionID	CHAR	20
SectionCmnt	CHAR	80
Instructor	CHAR	40
CourseItmReqDate	DATETIME
ReqType	CHAR	30
ReqQty	INT
EnrollEsti	INT
EnrollActu	INT
BookAuthor	CHAR	45
BookTitle	CHAR	128
BookISBN	CHAR	30
BookEdition	CHAR	20
BookBinding	CHAR	20
BookCopyright	CHAR	2
VendorCode	CHAR	10
VendorName	CHAR	50
SKUnew	INT
SKUused	INT
SKULinked	CHAR	1
SKUParent	INT
BookStatus	CHAR	15
BookStatusDate	DATETIME
ItemComment	CHAR	25
AdoptStatus	INT
NewOnly	INT
RetailNew	MONEY
RetailUsed	MONEY
RentalNew	MONEY
RentalUsed	MONEY
SOHNew	INT
SOHUsed	INT
OnOrderNew	INT
OnOrderUsed	INT

XML Definition

The XML definition uses the same fields as the ASCII Formats. Note: some fields will be omitted if there is no corresponding data. All attributes are CDATA #IMPLIED.

<?xml version="1.0"?>

<trn_univ_course_exports>

<trn_univ_course_export

TermName="2010PKSU"

TermDesc="KSU Fall 2010"

DeptName="ACCTG"

CourseName="231"

CourseDesc="Acctg For Bus Ops"

CourseCmnt=""

CourseSection="A"

SectionID="10001"

SectionCmnt="08/23/2010 ; LEC ; C208 ; MWF 07:30 AM ; Active"

Instructor="Ott, Richard L"

CourseItmReqDate=""

ReqType="Required"

ReqQty="40"

EnrollEsti="40"

EnrollActu="3"

BookAuthor="AINSWORTH"

BookTitle="INTRO TO ACCOUNTING"

BookISBN="978-0-07-813660-3"

BookEdition="6"

BookBinding="HARDBACK"

BookCopyright="11"

VendorCode="MCG001"

VendorName="McGraw Hill Inc."

SKUnew="11734451"

SKUused="11734468"

SKULinked=""

SKUParent="0"

BookStatus="Current Edition"

BookStatusDate=""

ItemComment="DUE 01/10"

AdoptStatus="1"

NewOnly="0"

RetailNew="207.4500"

RetailUsed="155.6000"

RentalNew=".0000"

RentalUsed=".0000"

SOHNew="0"

SOHUsed="0"

OnOrderNew="0"

OnOrderUsed="0"

/>