CONTRACT - Report
Data Element |
Business Definition |
Data Type |
Source Name |
Source Data Element |
Form Name |
ACADEMIC_YEAR |
ACADEMIC YEAR ASSOCIATED THIS RECORD. |
|
STVTERM |
STVTERM_ACYR_CODE |
UNKNOWN |
ACADEMIC_YEAR_DESC |
DESCRIPTION OF THE ACADEMIC YEAR ASSOCIATED WITH THIS RECORD. |
|
STVACYR |
STVACYR_DESC |
UNKNOWN |
ACADEMIC_PERIOD |
IDENTIFIES THE ACADEMIC PERIOD OR TERM ASSOCIATED WITH THIS INFORMATION. |
|
TSACONT |
TBBCSTU_TERM_CODE |
UNKNOWN |
ACADEMIC_PERIOD_DESC |
DESCRIPTION OF THE ACADEMIC PERIOD ASSOCIATED THIS RECORD. |
|
STVTERM |
STVTERM_DESC |
UNKNOWN |
SUB_ACADEMIC_PERIOD |
IDENTIFIES THE SUB ACADEMIC PERIOD OR PART OF TERM ASSOCIATED WITH THE INFORMATION. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
SUB_ACADEMIC_PERIOD_DESC |
DESCRIPTION OF THE SUB ACADEMIC PERIOD OR SESSION. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
START_DATE |
DATE THE SKILL WAS LEARNED. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
END_DATE |
DATE THE SKILL WAS ENDED. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
CONTRACT_NUMBER |
IDENTIFIES THE CONTRACT NUMBER ASSOCIATED WITH THE THIRD PARTY FOR THE ACADEMIC PERIOD. |
|
TBBCONT |
TBBCONT_CONTRACT_NUMBER |
UNKNOWN |
MAX_NUMBER_STUDENTS |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
MIN_NUMBER_STUDENTS |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
MAX_AMOUNT_FROM_THIRD_PARTY |
|
|
FUNCTION |
NOT AVAILABLE |
UNKNOWN |
MIN_AMOUNT_FROM_THIRD_PARTY |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
CONTRACT_DESC |
SPECIFIES THE FREE-FORMAT NAME OF THE THIRD PARTY CONTRACT FOR THE ACADEMIC PERIOD. |
|
TBBCONT |
TBBCONT_DESC |
UNKNOWN |
CONTRACT_EXP_DATE |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
CONTRACT_EXP_ACAD_PERIOD |
IF THE ROLL PROCESS SEES THAT THIS ACADEMIC PERIOD IS GREATER THAN THE ACADEMIC PERIOD THE CONTRACT IS BEING ROLLED TO |
|
TBBCONT |
TBBCONT_TERM_CODE_EXPIRATION |
UNKNOWN |
CONTRACT_EXP_ACAD_PERIOD_DESC |
DESCRIPTION OF THE ACADEMIC PERIOD ASSOCIATED THIS RECORD. |
|
STVTERM |
STVTERM_DESC |
UNKNOWN |
THIRD_PARTY_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
TBBCONT |
TBBCONT_PIDM |
UNKNOWN |
THIRD_PARTY_NAME |
NAME OF THE ORGANIZATION ENTITY. |
|
SPRIDEN |
SPRIDEN_LAST_NAME |
UNKNOWN |
THIRD_PARTY_ID |
ORGANIZATION'S ID NUMBER USED TO ACCESS ASSOCIATED RECORDS. |
|
SPRIDEN |
SPRIDEN_ID |
UNKNOWN |
DETAIL_CODE_PAY |
IDENTIFIES THE DETAIL CODE THAT HAS BEEN IDENTIFIED AS A PAYMENT TO BE POSTED AS THE THIRD PARTY PAYMENT ON THE STUDENTS ACCOUNT. |
|
TBBCONT |
TBBCONT_DETAIL_PAY_CODE |
UNKNOWN |
DETAIL_CODE_PAY_DESC |
DEFAULT TEXT DESCRIPTION TO BE USED FOR THE DETAIL CODE. |
|
TBBDETC |
TBBDETC_DESC |
UNKNOWN |
DETAIL_CODE_CHARGE |
IDENTIFIES THE DETAIL CODE THAT HAS BEEN IDENTIFIED AS A CHARGE TO BE POSTED AS THE CHARGE AGAINST THE THIRD PARTY'S ACCOUNT. |
|
TBBCONT |
TBBCONT_DETAIL_CHG_CODE |
UNKNOWN |
DETAIL_CODE_CHARGE_DESC |
DEFAULT TEXT DESCRIPTION TO BE USED FOR THE DETAIL CODE. |
|
TBBDETC |
TBBDETC_DESC |
UNKNOWN |
PERSON_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
TSACONT |
TBBCSTU_STU_PIDM |
UNKNOWN |
PERSON_ID |
IDENTIFICATION NUMBER FOR THE PERSON OR ENTITY. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
PERSON_FULL_NAME |
|
|
FUNCTION |
? |
UNKNOWN |
CONTRACT_PRIORITY |
SPECIFIES THE PRIORITY OF THIS CONTRACT FOR THE STUDENT |
|
TSACONT |
TBBCSTU_CONTRACT_PRIORITY |
UNKNOWN |
AUTHORIZED_IND |
INDICATOR SIGNIFYING WHETHER A STUDENT IS PRE-AUTHORIZED |
|
TBBCSTU |
TBBCSTU_AUTH_IND |
UNKNOWN |
AUTHORIZED_NUMBER |
NUMBER ISSUED FOR A STUDENT BY A THIRD PARTY WHEN A STUDENT IS AUTHORIZED TO USE A CONTRACT. |
|
TBBCSTU |
TBBCSTU_AUTH_NUMBER |
UNKNOWN |
AMOUNT_PAID |
AMOUNT PAID BY THE CONTRACT. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
PERSON_MAX_AMOUNT_PAID |
|
|
FUNCTION |
NOT AVAILABLE |
UNKNOWN |
PERSON_MAX_AMOUNT_AUTHORIZED |
SPECIFIES THE MAXIMUM AMOUNT A STUDENT CAN HAVE FOR THIS CONTRACT. |
|
TBBCSTU |
TBBCSTU_MAX_STUDENT_AMOUNT |
UNKNOWN |
CONTRACT_NEGOTIATED_ID |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
CONTRACT_NEGOTIATED_NAME |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
COURSES_COVERED_COUNT |
NUMBER OF THE COURSES COVERED BY A THIRD PARTY CONTRACT. NOT DETERMINED IN THE SCT BANNER PRODUCT LINE. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
PERSON_EXP_DATE |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
PERSON_EXP_ACAD_PERIOD |
ACADEMIC PERIOD WHEN THIS IS NOT LONGER ACTIVE. |
|
TBBCSTU |
TBBCSTU_TERM_CODE_EXPIRATION |
UNKNOWN |
PERSON_EXP_ACAD_PERIOD_DESC |
DESCRIPTION OF THE ACADEMIC PERIOD ASSOCIATED THIS RECORD. |
|
STVTERM |
STVTERM_DESC |
UNKNOWN |