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 |
---|---|---|---|
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"
/>
<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="Bookstore Alternate"
ReqQty="0"
EnrollEsti="40"
EnrollActu="3"
BookAuthor="AINSWORTH"
BookTitle="JUMPBOOK INTRO TO ACCOUNTING"
BookISBN="978-0-07-737783-0"
BookEdition="6"
BookBinding="JUMPBOOK"
BookCopyright="11"
VendorCode="MCG001"
VendorName="McGraw Hill Inc."
SKUnew="11734475"
SKUused="11734482"
SKULinked=""
SKUParent="0"
BookStatus="Current Edition"
BookStatusDate=""
ItemComment="JUMPBOOK"
AdoptStatus="1"
NewOnly="1"
RetailNew="78.5000"
RetailUsed="58.9000"
RentalNew=".0000"
RentalUsed=".0000"
SOHNew="0"
SOHUsed="0"
OnOrderNew="0"
OnOrderUsed="0"
/>
</trn_univ_course_exports>