Exports Course Details.
...
PrismCore Export_Univ_Course Table Names
(Use this for interfaces that bypass WPConsole and go directly to prism_trn)
...
Note: PRISM export is not supported.
Column |
|---|
...
Data Type |
|---|
...
------------------- --------- ------ -----------------------------------
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
...
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
...