Data Dictionary Keyword Search

This Data Dictionary contains student related Access.SMU database tables commonly used in the query tool. In the keyword search below you may enter the table name, field name, or the common name for the information you are seeking.

| List All Tables

Table Information for ITEM_LINE_SF:

Table: ITEM_LINE_SF - Item Line

Short Description: Charges and Payments

Long Description: Journal line entries for all charges and payments for a student, by term and account type.

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
COMMON_ID	Matches the value found in EMPLID
ITEM_NBR	Reference number for a line item
ACCOUNT_NBR	Account Number differentiates between tuition/fees, misc, and payment plan accounts
ACCOUNT_TERM	Term to which the financial transactions are attached.
POSTED_DATE	Post date for line item transaction
REF1_DESCR	Reference, or note, field
LINE_AMT	Amount of a line item transaction
ACAD_CAREER	Code for Academic Career. Value attached to the student.
ITEM_TERM	Term of the line item transaction
POSTED_DATETIME	Date/Time stamp for posted action
OPRID	ID of administrative user who performed this action
DESCR	Line Item (charge of payment) description
ITEM_TYPE_CD	Item Type Code, a transaction category (charge, financial aid, etc.)

Criteria Notes:

ACCOUNT_NBR = 'STUDENT001' has tuition, fees, housing, and meal plan charges. Also called the zero account (ACCOUNT_TYPE_SF).

ACCOUNT_NBR = 'MISC001' has charges for parking, library services, bookstore, and a few administrative fees. Also called the 9 account (ACCOUNT_TYPE_SF)

ACCOUNT_NBR = 'PMTPLAN001' is for moving balances to this account and managing payments under a payment plan

Fields COMMON_ID and EMPLID are the same, the student ID number

Related Tables: ACCOUNT_SF  ITEM_LNDDT_VW  ITEM_SF  ITEM_TYPE_FA  ITEM_TYPE_FA  ITEM_TYPE_FA  ITEM_TYPE_TBL  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.