Docstoc

PS Tables

Document Sample
PS Tables Powered By Docstoc
					STUDENT FINANCIALS VIEWS AND TABLES

Listing of Potentially Useful Student Financials Views and Tables

   Account Information
      ACCOUNT_SF - Account Balance by Emplid by Account Type
      ACCOUNT_TOT_VW - Total Account Balance by Emplid
      ACCOUNT_VW - Account Balance by Emplid by Term
      ITEM_SF - Account Transactions by Emplid by Item Number
      ITEM_LINE_SF - Acct Transactions by Emplid, by Item Number, Line Seq Number
      ITEM_XREF - Links Payments and Charges together by Item Nbr
      ITEM_XREF_VW - Links Payments and Charges together by Emplid by Item Nbr


   GL Interface Information
      SF_ACCTG_LN - SF Accounting Line


   Billing Information
      BI_BILL_HEADER - Billing Invoice Header
      BI_BILLING_LINE - Billing Line
      BI_ITEMSF_VW - Billing Item View


   Tuition Calculation Information
      TUIT_CALC_TBL - Tuition Calc Table
      CALC_MESSAGES - Tuition Calc Error/Warn Messages


   Student Career Information
      STDNT_CAR_TERM - Student Career Term Table


   Student Enrollment Information
      STDNT_ENRL - Student Enrollment Table


   Student Information
      STDNT_GRPS_HIST - Student Groups by Emplid
      PERSON_NAME - Current Primary Name View
      SRVC_IND_DATA - Service Indicator Data



    07/07/2008
    D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
Credit History Information
   CREDIT_HISTORY - Credit History information by Date and Emplid


Group Post Information
   GROUP_CONT_INFO - Control Group Input
   GROUP_LINE - Group Line Information/Check


Cashiering Information
   CSH_OFF_RECEIPT - Cashier Office Receipts
   CSH_OFF_RCPT_T - Cashier Office Receipt Tender
   CSH_OFF_RCPT_L - Cashier Office Receipt Line
   CSH_DP_RCPT_VW - Cashier Off Department Receipt View
   CSH_BD_REG_OPEN - Cashier Off Bus Dt Register Open Table
   CSH_BUS_DT_TBL - Cashier Off Business Date Table


Third Party Contract Information
   TP_CONTRACT - Third Party Contracts
   TP_STUDENT - Third Party Student


Refund Information
   REFUND_HDR - Refund Header Record
   REFUND_DTL - Refund Detail


Setup Information
   ACCT_TYP_TBL_SF - Account Type Table
   ITEM_TYPE_1_TBL - Item Type Control Table
   ITEM_TYPE_TBL - Item Type Table
   ITEM_TYPE_VW - Item Type View
   ITEM_ACCT_TYPE - Account Types by Item Type
   GL_INT_CD_TBL - General Ledger Dummy Parent
   GL_INT_DT_TBL - General Ledger Dummy Parent II
   GL_INTERFACE - General Ledger Interface by Item Type
   ADJ_CODE_TBL - Adjustment Code Table
   ADJ_TERM_TBL - Adjustment Code Term Table
   DUE_CODE_TBL - Due Date Code Table
   DUE_DATE_TBL - Due Date Table
   CLASS_FEE_TBL - Class Fee Table
   CLASS_SBFEE_TBL - Class Sub Fee Table

 07/07/2008
 D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
 CRSE_FEE_TBL - Course Fee Table
 CRSE_SUBFEE_TBL - Course Sub Fee Table
 TERM_FEE_TBL - Term Fee Table
 TERM_SUBFEE_TBL - Term Sub Fee Table




07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
Listing of Potentially Useful Student Records Tables

   Academic Calendar
      SESS_TIME_PEROD - Session Time Periods
      SESSION_TBL - Session Definition Table
      TERM_TBL - Term Definition Table
      TIME_PERIOD_TBL - Time Period Table

   Academic Information
      ACAD_CAR_TBL - Academic Career Table
      ACAD_GROUP_TBL - Academic Group Table
      ACAD_LEVEL_TBL - Academic Level Table
      ACAD_PLAN - Student Academic Plan Table
      ACAD_PLAN_TBL - Academic Plan Table
      ACAD_PROG - Student Academic Program
      ACAD_PROG_TBL - Academic Program Table
      ACAD_SUBPLAN - Student Academic Subplan Table
      ACAD_SUBPLN_TBL - Academic Sub Plan Table

   Class Information
      CLASS_ASSOC - Class Associations
      CLASS_ATTRIBUTE - Class Attribute Table
      CLASS_TBL - Class Table
      SCTN_CMBND - Sections Combined
      SCTN_CMBND_TBL - Sections Combined Table

   Course Information
      CRSE_ATTR_TBL - Course Print Attribute Table
      CRSE_ATTR_VALUE - Course Attribute Value Tbl
      CRSE_ATTRIBUTES - Course Attribute Tbl
      CRSE_CATALOG - Course Catalog Data
      CRSE_OFFER - Course Catalog Offerings

   General Information
      CAMPUS_TBL - Campus Table
      INSTITUTION_TBL - Institution Table


    07/07/2008
    D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
Student Information
  COUNTRY_TBL - Countries
  EMAIL_ADDRESSES - Email Addresses
  PSXLATITEM - Translate Value Items
  RESIDENCY_OFF - Official Residency Data
  STATE_TBL - State Codes/Names w/in Country
  STDNT_CONS_STAT - Student Consolidated Stats




 07/07/2008
 D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
Fields Included in Each Potentially Useful Student Financials View and Table
      ACCOUNT_SF - Account Balance by Emplid by Account Type
      Y   ACCOUNT_NBR - Account Nbr
      Y   ACCOUNT_TERM - Account Term
      Y   BUSINESS_UNIT - Business Unit
      Y   EMPLID - EmplID
          ACAD_YEAR - Academic Year
          ACCOUNT_BALANCE - Account Balance
          ACCOUNT_TYPE_SF - Account Type
          ACCT_STATUS - Account Status
          BILL_REQ_ID - Bill Request ID
          CLOSE_DT - Date Closed
          CONTRACT_NUM - Contract Number
          INCLUDE_BILLING - Include Billing
          INCLUDE_IN_BALANCE - Include in Balance
          INCLUDE_PREPAY - Include Pre-Pay
          INCLUDE_TRANSFER - Include Transfers
          LAST_ACCT_DT_AGED - Last Accounting Date Aged
          LAST_AGING_DT - Last Aging Date
          OPEN_DT - Created
          OVERR_BILL_REQ_ID - Override Bill Request ID

      ACCOUNT_TOT_VW - Total Account Balance by Emplid
      Y   BUSINESS_UNIT - Business Unit
      Y   EMPLID - EmplID
          ACCOUNT_BALANCE - Account Balance

      ACCOUNT_VW - Account Balance by Emplid by Term
      Y   ACCOUNT_NBR - Account Nbr
      Y   ACCOUNT_TERM - Account Term
      Y   BUSINESS_UNIT - Business Unit
      Y   EMPLID - EmplID
          ACCOUNT_BALANCE - Account Balance
          ACCOUNT_TYPE_SF - Account Type
          ACCT_STATUS - Account Status
          BASE_CURRENCY - Base Currency
          CONTRACT_NUM - Contract Number
          INCLUDE_IN_BALANCE - Include in Balance
          OPEN_DT - Created

      ACCOUNT_TYPE_TBL_SF - Account Types
      Y   SETID - SetID
      Y   ACCOUNT_TYPE_SF - Account Type
          ACCT_NUM_PREFIX - Account Nbr Prefix
          ACCT_PER_TERM - Account Per Term
          BALANCE_FWD_SW - Balance Forward
          CANCEL_CLASS - Include in Class Cancellation
          DESCR - Description
          DESCRSHORT - Short Description
          EXCLUDE_AGE_FLG - Exclude From Aging Total

    07/07/2008
    D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      INCLUDE_BILLING - Include Billing
      INCLUDE_IN_BALANCE - Include in Balance
      INCLUDE_PREPAY - Include Pre-Pay
      INCLUDE_TRANSFER - Include Transfers
      LATE_FEE_ACCT_IND - Late Fee Account
      LATE_FEE_ACCT_ORG - Ext Org Late Fee Account
      LATE_FEE_CODE - Late Fee Code
      LATE_FEE_CODE_ORG - Ext Org Late Fee Code
      MOVE_EXCESS_FA - Move Excess Financial Aid
      MOVE_EXCESS_PMT - Move Excess Payment
      MOVE_EXCESS_WAIVER - Move Excess Waiver
      PMT_PLAN_ACCT_FLG - Payment Plan Account
      PRIMARY_ACCOUNT - Primary Account
      SF_ACCOUNT_CLASS - Account Class
      UNAPP_PMT_CREDHIST - View Unappld Pymt Credit Hist

 ADJ_CODE_TBL - Adjustment Code Table
 Y    ADJ_TERM_CD - Adjustment Code
 Y    SETID - SetID
      ADJUST_OPTION - Adjustment Option
      DESCR - Description

 ADJ_TERM_TBL - Adjustment Code Term Table
 Y    ADJ_TERM_CD - Adjustment Code
 Y    ADJUST_REASON - Adjust Reason
 Y    FROM_ATTEND_PCT - From Classes Attended %
 Y    FROM_DAY - From Day
 Y    FROM_MEETING - From Meeting
 Y    SESSION_CODE - Session
 Y    SETID - SetID
 Y    STRM - Term
 Y    TO_ATTEND_PCT - To Classes Attended %
 Y    TO_DAY - To Day
 Y    TO_MEETING - To Meeting
      ACCOUNT_TYPE_SF - Account Type
      ADMIN_FEE - Administrative Fee
      ADMIN_FEE_PCT - Admin Fee Percentage
      CANCEL_ACCT_TYPE - Cancel Account Type
      CANCEL_FLAT_FEE - Cancel Flat Fee
      CANCEL_ITEM_TYPE - Cancel Item Type
      CURRENCY_CD - Currency Code
      DUE_DATE_CODE - Due Date Code
      ITEM_TYPE - Item Type
      MAX_AMOUNT - Maximum Amount
      REFUND_PCT - Refund Percentage

 BI_BILL_HEADER - Billing Invoice Header
 Y    BUSINESS_UNIT - Business Unit
 Y    INVOICE_ID - Invoice Number
      ACAD_CAREER - Academic Career
      ACAD_CAREER_INC - Academic Career

07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      ACAD_CAREER_SRCH - Academic Career
      ACAD_LEVEL_PROJ - Academic Level - Projected
      ACAD_LEVEL_PROJ_CL - Acad Level Proj Calculated
      ACAD_LVL_PROJ_SRCH - Academic Level - Projected
      ACAD_PLAN - Academic Plan
      ACAD_PLAN_INC - Academic Plan
      ACAD_PLAN_SRCH - Academic Plan
      ACAD_PROG - Academic Program
      ACAD_PROG_PRIMARY - Primary Academic Program
      ACAD_PROG_SRCH - Academic Program
      ACADEMIC_LOAD - Academic Load
      ADDR_FIELD1 - Address Field 1
      ADDR_FIELD2 - Address Field 2
      ADDR_FIELD3 - Address Field 3
      ADDRESS_TYPE - Address Type
      ADDRESS1 - Address Line 1
      ADDRESS2 - Address Line 2
      ADDRESS3 - Address Line 3
      ADDRESS4 - Address Line 4
      BI_REQ_NBR - Billing Request Nbr
      BI_SCAN_LINE - Bill Scan Line
      BILL_BY_IND - Bill By Indicator
      BILL_DATE_TIME - Bill Date and Time
      BILL_REQ_ID - Bill Request ID
      BILL_TYPE_ID - Bill Type ID
      CAMPUS - Campus
      CITY - City
      CONTACT_NAME - Contact Name
      CONTRACT_EMPLID - Contract ID
      CONTRACT_NUM - Contract Number
      COUNTRY - Country
      COUNTY - County
      DUE_DT - Expected Birth Date
      EMPLID - EmplID
      EXT_ORG_ID - External Org ID
      GEO_CODE - Tax Vendor Geographical Code
      HOUSE_TYPE - House Type
      IN_CITY_LIMIT - In City Limit
      INVOICE_DT - Invoice Date
      INVOICE_TYPE - Invoice Type
      MESSAGE_NBR - Message Number
      NAME - Name
      NUM1 - Number 1
      NUM2 - Number 2
      OPRID - User ID
      POSTAL - Postal Code
      PRIOR_INVOICE_ID - Prior Invoice ID
      PRIOR_IVC_BALANCE - Prior Invoice Amount
      PRT_BILL_FLAG - Print Bill Flag
      PRT_DTTM_STAMP - Print Date/Time Stamp
      RE_PRT_BILL_FLAG - RePrint Bill Flag
      RE_PRT_DTTM_STAMP - RePrint Date/Time Stamp

07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      SF_BILL_STATUS - Billing Status
      SSF_ERROR_WARN - Error or Warning Flag
      STATE - State
      TOTAL_BILL - Total Billed
      TUITION_RES - Tuition Residency
      TYPE_OF_REQUEST - Type of Request

 BI_BILLING_LINE - Billing Line
 Y    BUSINESS_UNIT - Business Unit
 Y    COMMON_ID - ID
 Y    INVOICE_ID - Invoice Number
 Y    ITEM_LINE - Item Line
 Y    ITEM_NBR - Item Nbr
 Y    SA_ID_TYPE - ID Type

 BI_ITEMSF_VW - Billing Item View
 Y    BUSINESS_UNIT - Business Unit
 Y    COMMON_ID - ID
 Y    ITEM_NBR - Item Nbr
      ACAD_YEAR - Academic Year
      ACCOUNT_NBR - Account Nbr
      ACCOUNT_TERM - Account Term
      APPLIED_AMT - Applied Amount
      BALANCE_AMT - Charge Balance
      CONTRACT_EMPLID - Contract ID
      DESCR - Description
      DUE_DT - Due Date
      EFFDT - Effective Date
      EMPLID - EmplID
      EXT_ORG_ID - External Org ID
      INSTITUTION - Academic Institution
      ITEM_AMT - Item Amount
      ITEM_BALANCE - Item Balance
      ITEM_TERM - Item Term
      ITEM_TYPE - Item Type
      ITEM_TYPE_CD - Item Type Code
      LINE_AMT - Line Amount
      LINE_REASON_CD - Line Reason Code
      LINE_SEQ_NBR - Line Sequence Nbr
      NAME - Name
      PAYMENT_ID_NBR - Payment ID Nbr
      POSTED_DATE - Date Posted
      POSTED_DATETIME - Posted Date & Time
      REF1_DESCR - Reference Nbr
      REFUND_NBR - Refund Nbr
      SESSION_CODE - Session
      SETID - SetID

 CALC_MESSAGES - Tuition Calc Error/Warn Messages
 Y    BATCH_ID - Batch ID
 Y    BUSINESS_UNIT - Business Unit

07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
 Y    EMPLID - EmplID
 Y    LINE_SEQ_NBR - Line Sequence Nbr
 Y    STRM - Term
      ACAD_CAREER - Academic Career
      ACAD_PROG - Academic Program
      BATCH_RUN_DATE - Batch Run Date
      MESSAGE_NBR - Message Number
      MESSAGE_SET_NBR - Message Set Number
      OPRID - User ID
      SSF_ADDED_BY - Added By
      SSF_ERROR_WARN - Error or Warning Flag

 CLASS_FEE_TBL - Class Fee Table
 Y    CLASS_SECTION - Class Section
 Y    CRSE_ID - Course ID
 Y    CRSE_OFFER_NBR - Course Offering Nbr
 Y    SESSION_CODE - Session
 Y    SETID - SetID
 Y    SSR_COMPONENT - Course Component
 Y    STRM - Term
      AUDIT_RT_FLAG - Audit Rate specified
      CALC_OTHER_WDRW - Include in other Withdrawal
      CALC_PRO_RATA - Include in Pro-rata
      CHARGE_CRSE_FEE - Charge for Course Fee
      CHARGE_METHOD - Charge Method
      CHARGE_WAIT_LIST - Charge for Wait Listed Class
      FEE_CD - Fee Code

 CLASS_SBFEE_TBL - Class Sub Fee Table
 Y    ACCOUNT_TYPE_SF - Account Type
 Y    CLASS_SECTION - Class Section
 Y    CRSE_ID - Course ID
 Y    CRSE_OFFER_NBR - Course Offering Nbr
 Y    ITEM_TYPE - Item Type
 Y    SESSION_CODE - Session
 Y    SETID - SetID
 Y    SSR_COMPONENT - Course Component
 Y    STRM - Term
      ADJ_TERM_CD - Adjustment Code
      AMT_PER_UNIT - Amount Per Unit
      AMT_PER_UNIT_AUDIT - Amt / Unit (Audit)
      CRSE_RATE_ID - Course Rate ID
      CURRENCY_CD - Currency Code
      DUE_DATE_CODE - Due Date Code
      DYNAMIC_ORG - Dynamic Organization
      EQUATION_NAME - Equation Name
      FEE_TRIGGER - Fee Trigger
      FLAT_AMT - Flat Amount
      FLAT_AMT_AUDIT - Flat Amt (Audit)
      MAX_AMOUNT - Maximum Amount
      MIN_AMOUNT - Minimum Amount


07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      SSF_CRITR_EQUTN_SW - Criteria / Equation
      SSF_EXCLUDE_HECS - Exclude Classes w/ HECS Status
      WAIVER_GROUP - Waiver Group

 CREDIT_HISTORY - Credit History information by Date and Emplid
 Y    ACCOUNT_NBR - Account Nbr
 Y    ACCOUNT_TERM - Account Term
 Y    AGE_CATEGORY - Aging Category
 Y    AGING_SET - Aging Set
 Y    BUSINESS_UNIT - Business Unit
 Y    EFFDT - Effective Date
 Y    EMPLID - EmplID
 Y    EXT_ORG_ID - External Org ID
      ACCOUNT_TYPE_SF - Account Type
      AMOUNT - Amount
      LAST_DTTM_UPDATE - Last Change Date

 CRSE_FEE_TBL - Course Fee Table
 Y    CAMPUS - Campus
 Y    CRSE_ID - Course ID
 Y    INSTITUTION - Academic Institution
 Y    LOCATION - Location Code
 Y    SESSION_CODE - Session
 Y    SETID - SetID
 Y    SSR_COMPONENT - Course Component
 Y    STRM - Term
      AUDIT_RT_FLAG - Audit Rate specified
      CALC_OTHER_WDRW - Include in other Withdrawal
      CALC_PRO_RATA - Include in Pro-rata
      CHARGE_METHOD - Charge Method
      CHARGE_WAIT_LIST - Charge for Wait Listed Class
      FEE_CD - Fee Code

 CRSE_SUBFEE_TBL - Course Sub Fee Table
 Y    ACCOUNT_TYPE_SF - Account Type
 Y    CAMPUS - Campus
 Y    CRSE_ID - Course ID
 Y    INSTITUTION - Academic Institution
 Y    ITEM_TYPE - Item Type
 Y    LOCATION - Location Code
 Y    SESSION_CODE - Session
 Y    SETID - SetID
 Y    SSR_COMPONENT - Course Component
 Y    STRM - Term
      ADJ_TERM_CD - Adjustment Code
      AMT_PER_UNIT - Amount Per Unit
      AMT_PER_UNIT_AUDIT - Amt / Unit (Audit)
      CRSE_RATE_ID - Course Rate ID
      CURRENCY_CD - Currency Code
      DUE_DATE_CODE - Due Date Code


07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      DYNAMIC_ORG - Dynamic Organization
      EQUATION_NAME - Equation Name
      FEE_TRIGGER - Fee Trigger
      FLAT_AMT - Flat Amount
      FLAT_AMT_AUDIT - Flat Amt (Audit)
      MAX_AMOUNT - Maximum Amount
      MIN_AMOUNT - Minimum Amount
      SSF_CRITR_EQUTN_SW - Criteria / Equation
      SSF_EXCLUDE_HECS - Exclude Classes w/ HECS Status
      WAIVER_GROUP - Waiver Group

 CSH_BD_REG_OPEN - Cashier Off Bus Dt Register Open Table
 Y    BUSINESS_DATE - Business Date
 Y    BUSINESS_UNIT - Business Unit
 Y    CASHIER_OFFICE - Cashier's Office
 Y    CURRENCY_CD - Currency Code
 Y    SF_REGISTER - Cash Register
 Y    TENDER_KEY - Tender Key
      CLOSING_BALANCE - Closing Balance
      GL_SENT_OVER_AMT - GL Sent Over Amount
      GL_SENT_SHORT_AMT - GL Sent Short Amount
      OPENING_BALANCE - Opening Balance
      OVER_AMOUNT - Over Amount
      SF_DEPOSIT_ID - Deposit ID
      SHORT_AMOUNT - Short Amount

 CSH_BUS_DT_TBL - Cashier Off Business Date Table
 Y    BUSINESS_DATE - Business Date
 Y    BUSINESS_UNIT - Business Unit
 Y    CASHIER_OFFICE - Cashier's Office
      CLOSE_DTTM - Close Datetime
      CLOSE_OPRID - Close Operator
      GL_INT_RUN - GL Interface Run Status
      GROUP_ID_CORP - Group ID
      GROUP_ID_EMPLID - Group ID
      LAST_RCPT_NBR_BD - Last Receipt Nbr
      OPEN_DTTM - Open Datetime
      OPEN_OPRID - Open Operator

 CSH_DP_RCPT_VW - Cashier Off Department Receipt View
 Y    BUSINESS_UNIT - Business Unit
 Y    CASHIER_OFFICE - Cashier's Office
 Y    RECEIPT_NBR - Receipt Number
      CASHIER - Cashier
      CO_TRANS_TYPE - Cashier Office Trans Type
      CURRENT_BUS_DT - Current Business Date
      EMPLID - EmplID
      RECEIPT_NBR_BD - Business Date Sequence Nbr
      SF_REGISTER - Cash Register
      SSF_APPR_STATUS - Approval Status


07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      TOTAL_AMOUNT_SF - Total Amount
      TRANS_DT - Transaction Date
      TRANS_TIME - Transaction Time

 CSH_OFF_RCPT_L - Cashier Office Receipt Line
 Y    BUSINESS_UNIT - Business Unit
 Y    CASHIER_OFFICE - Cashier's Office
 Y    RECEIPT_LINE_NBR - Receipt Line Number
 Y    RECEIPT_NBR - Receipt Number
      ACCOUNT - Account
      AFFILIATE - Affiliate
      AFFILIATE_INTRA1 - Fund Affiliate
      AFFILIATE_INTRA2 - Operating Unit Affiliate
      ALTACCT - Alternate Account
      AMOUNT_SF - Amount
      BUDGET_REF - Budget Reference
      BUSINESS_UNIT_GL - General Ledger Unit
      CHARTFIELD1 - Chartfield 1
      CHARTFIELD2 - Chartfield 2
      CHARTFIELD3 - Chartfield 3
      CLASS_FLD - Class Field
      CSH_OFF_TRAN_TYPE - Cashier's Office Transaction
      CURRENCY_CD - Currency Code
      DEPTID - Department
      EXT_GL_CHARTFLD - External GL Chart Field
      FUND_CODE - Fund Code
      LEDGER - Ledger
      OPERATING_UNIT - Operating Unit
      PRODUCT - Product
      PROGRAM_CODE - Program Code
      PROJECT_ID - Project/Grant
      STRM - Term
      TARGET_KEY - Target Key
      TAX_AUTHORITY_CD - Tax Authority
      TAX_LINE_NBR - Tax Line Number
      TAX_ROW - Tax

 CSH_OFF_RCPT_T - Cashier Office Receipt Tender
 Y    BUSINESS_UNIT - Business Unit
 Y    CASHIER_OFFICE - Cashier's Office
 Y    RECEIPT_LINE_NBR - Receipt Line Number
 Y    RECEIPT_NBR - Receipt Number
      ADDR_FIELD1 - Address Field 1
      ADDR_FIELD2 - Address Field 2
      ADDR_FIELD3 - Address Field 3
      ADDRESS1 - Address Line 1
      ADDRESS2 - Address Line 2
      ADDRESS3 - Address Line 3
      ADDRESS4 - Address Line 4
      AMOUNT_SF - Amount
      BANK_ACCT_NAME - Bank Account Holder Name

07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      BANK_ACCT_TYP - Bank Account Type
      BANK_CD - Bank ID
      CHANGE_FLAG - Change Flag
      CHECK_NUM_SF - Check Nbr
      CITY - City
      COUNTRY - Country
      COUNTY - County
      CR_CARD_A_DTTM - Credit Card Authorization DTTM
      CR_CARD_AUTH_CD - Credit Card Authorization Code
      CR_CARD_AUTH_DT - Auth Date
      CR_CARD_AUTH_REPLY - Authorization Reply
      CR_CARD_AVS_CD - Credit Card AVS Return Code
      CR_CARD_DECLND - Credit Card Declined
      CR_CARD_DIGITS - Card Number's Last Four Digits
      CR_CARD_ERRMSG - Credit Card Error Message
      CR_CARD_EXP_DT - Expiration Date
      CR_CARD_FNAME - Credit Card First Name
      CR_CARD_ISSUER - Credit Card Issuer
      CR_CARD_LNAME - Credit Card Last Name
      CR_CARD_NBR - Credit Card Number
      CR_CARD_RQST_ID - Credit Card Request ID
      CR_CARD_STATUS - Credit Card Processing Status
      CR_CARD_TYPE - Credit Card Type
      CR_CARD_VDAUTH - Credit Card Void Auth Code
      CUR_RT_TYPE - Exchange Rate Type
      CURRENCY_CD - Currency Code
      EMAIL_ADDR - Email Address
      FED_RSRV_BANK_ID - Federal Reserve Bank ID
      GEO_CODE - Tax Vendor Geographical Code
      HOUSE_TYPE - House Type
      IN_CITY_LIMIT - In City Limit
      NUM1 - Number 1
      NUM2 - Number 2
      ORIGNL_CURRENCY_CD - Currency Code
      ORIGNL_ITEM_AMT - Item Amount
      PHONE - Telephone
      POSTAL - Postal Code
      RATE_DIV - Rate Divisor
      RATE_MULT - Rate Multiplier
      SF_DEPOSIT_ID - Deposit ID
      SF_PMT_REF_NBR - Reference Nbr
      SSF_BNK_ACCT_NUM - Account Number
      STATE - State
      TENDER_KEY - Tender Key
      THIRD_PARTY - Third Party Check Name
      TRACER_NBR - Bank Tracer Nbr

 CSH_OFF_RECEIPT - Cashier Office Receipts
 Y    BUSINESS_UNIT - Business Unit
 Y    CASHIER_OFFICE - Cashier's Office
 Y    RECEIPT_NBR - Receipt Number


07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      APPROVAL_DATETIME - Datetime Approval
      CASHIER - Cashier
      CHANGE_DUE - Change Due
      CO_TRANS_TYPE - Cashier Office Trans Type
      CONTRACT_EMPLID - Contract ID
      CONTRACT_NUM - Contract Number
      CR_CARD_SRVC_PROV - Credit Card Service Provider
      CURRENCY_CD - Currency Code
      CURRENT_BUS_DT - Current Business Date
      EMPLID - ID
      ENTERED_BY_CASHIER - Entering Cashier
      ENTERED_DATETIME - Entered Datetime
      EXT_ORG_ID - External Org ID
      ORIG_RECEIPT_NBR - Original Receipt Number
      RECEIPT_NBR_BD - Business Date Sequence Nbr
      REF1_DESCR - Reference Nbr
      SF_MERCHANT_ID - SF Merchant ID
      SF_REGISTER - Cash Register
      SSF_APPR_STATUS - Approval Status
      SSF_GL_IFC_RUN - GL Interface Run
      TOTAL_AMOUNT_SF - Total Amount
      TRANS_DT - Transaction Date
      TRANS_TIME - Transaction Time
      VOID_REASON_CD - Void Reason Code

 DUE_CODE_TBL - Due Date Code Table
 Y    DUE_DATE_CODE - Due Date Code
 Y    SETID - SetID
      DESCR - Description
      DESCRSHORT - Short Description
      DUE_DATE_PIVOT_DT - Due Date Pivot Date

 DUE_DATE_TBL - Due Date Table
 Y    BILL_DAYS - Days from Run Date
 Y    BILL_DT_DAYS - Days from Pivot Date
 Y    DUE_DATE_CODE - Due Date Code
 Y    DUE_DAYS - Due Days
 Y    DUE_DT_DAYS - Days from Pivot Date
 Y    FROM_DAY - From Day
 Y    SESSION_CODE - Session
 Y    SETID - SetID
 Y    STRM - Term
 Y    TO_DAY - To Day
 Y    USE_BILL_DATE - Billing Date Calc
 Y    USE_DATE - Due Date Calc
      DUE_PCT - Due Percentage

 GL_INT_CD_TBL - General Ledger Dummy Parent
 Y    ITEM_TYPE - Item Type
 Y    SESSION_CODE - Session


07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
 Y    SETID - SetID
 Y    STRM - Term

 GL_INT_DT_TBL - General Ledger Dummy Parent II
 Y    EFFDT - Effective Date
 Y    ITEM_TYPE - Item Type
 Y    SESSION_CODE - Session
 Y    SETID - SetID
 Y    STRM - Term
      AP_ACCOUNT - Account
      AP_AFF_INT1 - Fund Affiliate
      AP_AFF_INT2 - Operating Unit Affiliate
      AP_AFFILIATE - Affiliate
      AP_ALTACCT - Alternate Account
      AP_BUD_REF - Budget Reference
      AP_BUS_UNIT - Business Unit
      AP_CF1 - Chartfield 1
      AP_CF2 - Chartfield 2
      AP_CF3 - Chartfield 3
      AP_CLASS_FLD - Class
      AP_DEPTID - Department
      AP_FUND_CODE - Fund
      AP_LEDGER - Ledger
      AP_OP_UNIT - Operating Unit
      AP_PRODUCT - Product
      AP_PROG_CODE - Program
      AP_PROJ_ID - Project ID
      EFF_STATUS - Status as of Effective Date
      EXT_WRITEOFF - External Writeoff
      WRITEOFF_ACCOUNT - Account
      WRITEOFF_AFF_INT1 - Fund Affiliate
      WRITEOFF_AFF_INT2 - Operating Unit Affiliate
      WRITEOFF_AFFILIATE - Affiliate
      WRITEOFF_ALTACCT - Alternate Account
      WRITEOFF_BUD_REF - Budget Reference
      WRITEOFF_BUS_UNIT - Business Unit
      WRITEOFF_CF1 - Chartfield 1
      WRITEOFF_CF2 - Chartfield 2
      WRITEOFF_CF3 - Chartfield 3
      WRITEOFF_CLASS_FLD - Class Field
      WRITEOFF_DEPTID - Department
      WRITEOFF_FUND_CODE - Fund Code
      WRITEOFF_LEDGER - Ledger
      WRITEOFF_OP_UNIT - Operating Unit
      WRITEOFF_PRODUCT - Product
      WRITEOFF_PROG_CODE - Program Code
      WRITEOFF_PROJ_ID - Project ID

 GL_INTERFACE - General Ledger Interface by Item Type
 Y    ACCT_TYPE_SEQ - Account Type Sequence Nbr
 Y    DB_CR_IND - Debit Credit Indicator

07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
 Y    EFFDT - Effective Date
 Y    GL_INT_TIMING - GL Interface Timing
 Y    ITEM_TYPE - Item Type
 Y    SESSION_CODE - Session
 Y    SETID - SetID
 Y    STRM - Term
      ACCOUNT - Account
      AFFILIATE - Affiliate
      AFFILIATE_INTRA1 - Fund Affiliate
      AFFILIATE_INTRA2 - Operating Unit Affiliate
      ALTACCT - Alternate Account
      BUDGET_REF - Budget Reference
      BUSINESS_UNIT - Business Unit
      CHARTFIELD1 - Chartfield 1
      CHARTFIELD2 - Chartfield 2
      CHARTFIELD3 - Chartfield 3
      CLASS_FLD - Class Field
      CURRENCY_CD - Currency Code
      DEFERRED_ACCOUNT - Deferred Account
      DEFERRED_AFF_INT1 - Fund Affiliate
      DEFERRED_AFF_INT2 - Operating Unit Affiliate
      DEFERRED_AFFILIATE - Affiliate
      DEFERRED_ALTACCT - Alternate Account
      DEFERRED_BUD_REF - Budget Reference
      DEFERRED_BUS_UNIT - Business Unit
      DEFERRED_CF1 - Chartfield 1
      DEFERRED_CF2 - Chartfield 2
      DEFERRED_CF3 - Chartfield 3
      DEFERRED_CLASS_FLD - Class Field
      DEFERRED_DEPTID - Deferred Deptid
      DEFERRED_DT - Deferred Date
      DEFERRED_DYN_ORG - Deferred Dynamic Org
      DEFERRED_FUND_CODE - Deferred Fund
      DEFERRED_LEDGER - Deferred-Ledger
      DEFERRED_OP_UNIT - Operating Unit
      DEFERRED_PRODUCT - Product
      DEFERRED_PROG_CODE - Deferred Program Code
      DEFERRED_PROJ_ID - Deferred Project ID
      DEFERRED_REVENUE - Defer Revenue
      DEPTID - Department
      DYNAMIC_ORG - Dynamic Organization
      EXT_DEFERRED - External Deferred
      EXT_GL_CHARTFLD - External GL Chart Field
      FUND_CODE - Fund Code
      GL_INTERFACE_PCT - GL Interface Percent
      GL_LIMIT_AMT - GL Acct Limit Amt
      GL_PRIORITY_AMT - Priority Amount
      JOURNAL_SET - Journal Set Sequence Nbr
      LEDGER - Ledger
      OPERATING_UNIT - Operating Unit
      PRIORITY - Priority
      PRODUCT - Product

07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      PROGRAM_CODE - Program Code
      PROJECT_ID - Project/Grant

 GROUP_CONT_INFO - Control Group Input
 Y    BUSINESS_UNIT - Business Unit
 Y    GROUP_ID_SF - Group ID
      ACCOUNTING_DT - Accounting Date
      APPR_DATETIME_LAST - Last Datetime Approval
      APPR_OPRID_LAST - Operator ID Last Approval
      APPROVAL_DATETIME - Datetime Approval
      APPROVAL_OPRID - Operator ID Approval
      ASSN_OPRID - Assigned Operator ID
      BAL_STATUS - Deposit Balance
      BALANCE_GRP - Balance the Group
      BEGIN_GRP_ID - Begin Group ID
      CONTROL_AMT - Control Total
      CONTROL_CNT - Control Count
      CONTROL_CURRENCY - Control Currency
      DIFFERENCE_AMT - Difference Amount
      DIFFERENCE_CNT - Difference Count
      EDIT_STATUS - Editing
      END_GRP_ID - Group ID
      ENTERED_AMT - Entered Total
      ENTERED_CNT - Entered Count
      ENTRY_DT - Entry Date
      FROM_DATE - From Date
      GROUP_ID_ORIG - Original Group ID
      GROUP_SOURCE - Group Source
      GROUP_TYPE - Group Type
      MESSAGE_NBR - Message Number
      OPRID - User ID
      ORIGIN_ID - Origin ID
      POST_ACTION - Posting Action
      POST_DT - Posted Date
      POST_STATUS - Posting Status
      POSTED_COUNT - Payments Set To Post
      POSTED_TOTAL - Posted Total
      PROCESS_INSTANCE - Process Instance
      RECEIVED_DT - Certificate Received Date
      TO_DATE - Latest Date to be sent to PYR
      TYPE_OF_GROUP - Type of Group

 GROUP_LINE - Group Line Information/Check
 Y    BUSINESS_UNIT - Business Unit
 Y    GROUP_ID_SF - Group ID
 Y    GROUP_LINE_NBR - Group Line Number
      ACAD_CAREER - Academic Career
      ACAD_PROG - Academic Program
      ACAD_PROG2 - Academic Program
      ACAD_PROG3 - Academic Program 3
      ACAD_YEAR - Academic Year

07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      ACCOUNT_NBR - Account Nbr
      ACCOUNT_TERM - Account Term
      ACCOUNT_TYPE_SF - Account Type
      ACTUAL_BILLING_DT - Actual Billing Date
      ADM_APPL_NBR - Application Nbr
      AGING_DT - Aging Date
      AGING_FLG - Aging Flag
      AID_YEAR - Aid Year
      BANK_ACCT_NAME - Bank Account Holder Name
      BANK_ACCT_TYP - Bank Account Type
      BANK_CD - Bank ID
      BILLING_CAREER - Billing Career
      BILLING_DT - Billing Date
      BILLING_FLAG - Billing Flag
      CHARGE_PRIORITY - Charge Priority List
      CHARGE_SET_TABLE - Charge Set Table Flag
      CHECK_NUM_SF - Check Nbr
      CLASS_NBR - Class Nbr
      CLASS_PRICE_DTTM - Class Price Date Time
      COLLECTION_ID - Collection ID
      CONTRACT_EMPLID - Contract ID
      CONTRACT_NUM - Contract Number
      COURSE_LIST - Course List
      CR_CARD_DIGITS - Card Number's Last Four Digits
      CREATE_ITEM - Create Item
      CREDIT_CARD_EXP_DT - Expiration Date
      CREDIT_CARD_HOLDER - Credit Card Holder
      CREDIT_CARD_ISSUER - Credit Card Issuer
      CREDIT_CARD_NBR - Card Number
      CREDIT_CARD_TYPE - Credit Card Type
      CRSE_ID - Course ID
      CUR_RT_TYPE - Exchange Rate Type
      CURRENCY_CD - Currency Code
      DEPOSIT_NBR - Deposit Nbr
      DESCR - Description
      DISBURSEMENT_DATE - Disbursement Date
      DUE_DT - Due Date
      EMPLID - EmplID
      EMPLID_SET_TABLE - Emplid Set Table
      ENCUMBERED_AMT - Amount Encumbered
      ENCUMBRANCE_DT - Encumbrance Date
      EXC_ACCT_TYPE_FLG - Excess Account Type Flag
      EXC_ACCT_TYPE_SF - Excess Account Type SF
      EXT_ORG_ID - External Org ID
      EXTRA_REFUND_FLAG - Extra Refund Flag
      FED_RSRV_BANK_ID - Federal Reserve Bank ID
      FEE_CD - Fee Code
      FINANCE_CHARGE - Finance Charge
      GL_FROM_SUBFEE - GL from Sub Fees
      INSTITUTION - Academic Institution
      ITEM_AMT - Item Amount
      ITEM_EFFECTIVE_DT - Item Effective Date

07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      ITEM_NBR - Item Nbr
      ITEM_NBR_SOURCE - Item Nbr - Src Charge Nbr
      ITEM_TYPE - Item Type
      ITEM_TYPE_CD - Item Type Code
      LATE_FEE_CODE - Late Fee Code
      LINE_ACTION - Line Action
      LINE_REASON_CD - Line Reason Code
      LINE_STATUS - Line Status
      OPRID_QCKPOST - Quick Post Oprid
      ORG_GROUP_ID_SF - Original Group ID
      ORG_GROUP_LINE_NBR - Original Group Line Nbr
      ORIG_EFF_DT - Original Effective Date
      ORIGNL_CURRENCY_CD - Currency Code
      ORIGNL_ITEM_AMT - Item Amount
      OVERRIDE_APPL_NBR - Override Application Number
      PAYMENT_ID_NBR - Payment ID Nbr
      PAYMENT_METHOD - Payment Method
      PAYMENT_PRIORITY - Payment Priority
      POST_DT - Posted Date
      POST_FLAG - Line Post Flag
      PRIOR_POST_VAL - Prior Post Value
      PRIORITY - Priority
      PRIORITY_PMT_FLG - Payment Priority Flag
      RATE_DIV - Rate Divisor
      RATE_MULT - Rate Multiplier
      RECEIPT_NBR - Receipt Number
      REF1_DESCR - Reference Nbr
      REFUND_EMPLID - Refund ID
      REFUND_NBR - Refund Nbr
      RESTRICT_ACCT_FLG - Pay Entered Acct Only
      SEL_GROUP - Tuition Group
      SESSION_CODE - Session
      SF_DEPOSIT_ID - Deposit ID
      SF_PMT_REF_NBR - Reference Nbr
      SF_REVERSAL_IND - Reversal Indicator
      SRVC_IND_CD - Service Indicator Cd
      SSF_BNK_ACCT_NUM - Account Number
      SSF_ERROR_WARN - Error or Warning Flag
      STDNT_CAR_NBR - Student Career Nbr
      STRM - Term
      TAX_AUTHORITY_CD - Tax Authority
      TENDER_CATEGORY - Tender Category
      TENDER_SPEC - Tender Specific
      THIRD_PARTY - Third Party Check Name
      TRACER_NBR - Bank Tracer Nbr
      TRANS_FEE_CD - Transaction Fee Code
      WAIVER_CODE - Waiver Code
      WRITEOFF_BY - Writeoff By

 ITEM_ACCT_TYPE - Account Types by Item Type
 Y    ACCOUNT_TYPE_SF - Account Type


07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
 Y    EFFDT - Effective Date
 Y    ITEM_TYPE - Item Type
 Y    SETID - SetID
      SETID2 - 2nd SetId

 ITEM_LINE_SF - Acct Transactions by Emplid, by Item Number, Line Seq Number
 Y    BUSINESS_UNIT - Business Unit
 Y    COMMON_ID - ID
 Y    ITEM_NBR - Item Nbr
 Y    LINE_SEQ_NBR - Line Sequence Nbr
 Y    SA_ID_TYPE - ID Type
      ACAD_CAREER - Academic Career
      ACCOUNT_NBR - Account Nbr
      ACCOUNT_TERM - Account Term
      ACTUAL_BILLING_DT - Actual Billing Date
      AGING_DT - Aging Date
      AGING_FLG - Aging Flag
      AGING_LATE_FEES_DT - Late Fees Last Aging Aging Dt
      AGING2_FLAG - Aging Flag
      BILLING_DT - Billing Date
      BILLING_FLAG - Billing Flag
      CLASS_NBR - Class Nbr
      CLASS_PRICE_DTTM - Class Price Date Time
      COLLECTION_ID - Collection ID
      COMPANY - Company
      CONTRACT_NUM - Contract Number
      DEPOSIT_NBR - Deposit Nbr
      DESCR - Description
      DISPUTE_AMT - Dispute Amount
      DISPUTE_DT - Dispute Date
      DUE_AMT - Due Amount
      DUE_DATE_BY - Due Date Enter By
      DUE_DT - Due Date
      EMPLID - EmplID
      ENCUMBERED_AMT - Amount Encumbered
      ENCUMBRANCE_DT - Encumbrance Date
      EXT_ORG_ID - External Org ID
      FEE_CD - Fee Code
      FINANCE_CHARGE - Finance Charge
      GL_POSTING_DTTM - GL Posting Date Time
      GRP_TIMESTAMP - Group Line Time Stamp
      ITEM_EFFECTIVE_DT - Item Effective Date
      ITEM_TERM - Item Term
      ITEM_TYPE_CD - Item Type Code
      LINE_ACTION - Line Action
      LINE_AMT - Line Amount
      LINE_NUM - Line #
      LINE_REASON_CD - Line Reason Code
      LINE_REVERSAL_IND - Line Reversal Indicator
      LINE_STATUS - Line Status
      OFF_CYCLE - Off Cycle ?


07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      OPRID - User ID
      ORG_GROUP_ID_SF - Original Group ID
      ORG_GROUP_LINE_NBR - Original Group Line Nbr
      ORIG_DUE_DATE - Original Due Date
      ORIGINAL_ACCT_TERM - Original Account Term
      PAGE_NUM - Page #
      PAY_END_DT - Pay Period End Date
      PAYCHECK_NBR - Paycheck Number
      PAYGROUP - Pay Group
      PAYMENT_ID_NBR - Payment ID Nbr
      POSTED_DATE - Date Posted
      POSTED_DATETIME - Posted Date & Time
      REF1_DESCR - Reference Nbr
      REFUND_EMPLID - Refund ID
      REFUND_NBR - Refund Nbr
      SEL_GROUP - Tuition Group
      SENT_HRNRA_FLAG - Sent/Calculated fro HR NRA
      SESSION_CODE - Session
      STDNT_CAR_NBR - Student Career Nbr
      T4_SENT_FLG - T4 Sent Flag
      TRACER_NBR - Bank Tracer Nbr

 ITEM_SF - Account Transactions by Emplid by Item Number
 Y    BUSINESS_UNIT - Business Unit
 Y    COMMON_ID - ID
 Y    ITEM_NBR - Item Nbr
 Y    SA_ID_TYPE - ID Type
      ACAD_CAREER - Academic Career
      ACAD_YEAR - Academic Year
      ACCOUNT_NBR - Account Nbr
      ACCOUNT_TERM - Account Term
      ACCOUNT_TYPE_SF - Account Type
          ADM       Admission Fees
          CNV       Converson Balance from ISIS
          END       Enrollment Deposits Paid         UMS01
          ENR       Enrollment Fees
          MCF       Misc Charges and Fines
          OTH       Other
          PP        Payment Plans                    UMS01
          PPL       Payment Plans
          PRL       Payroll Deduction Payment Plan   UMS03,UMS04,UMS07
          RMB       Room and Board
          SCH       Scholarships                     UMS01
          SPN       Sponsored Charges
          TUT       Tuition
          UND       Undefined Postings
          XCP       Cross Campus Account
          XFA       Excess Financial Aid
          XPY       Excess Payments
          XWA       Excess Waivers                   UMS06
          XWV       Excess Waiver Account            UMS01,UMS02,UMS03,UMS04,UMS05,UMS07


07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      ACTUAL_BILLING_DT - Actual Billing Date
      ADM_APPL_NBR - Application Nbr
      AID_YEAR - Aid Year
      APPLIED_AMT - Applied Amount
      BILLING_CAREER - Billing Career
      BILLING_DT - Billing Date
      CALENDAR_YEAR - Calendar Year
      CHARGE_PRIORITY - Charge Priority List
      CLASS_CRSE_FEE_IND - Class/Course Fee Indicator
      CLASS_NBR - Class Nbr
      COLLECTION_ID - Collection ID
      CONTRACT_AMT - Contract Amt
      CONTRACT_EMPLID - Contract ID
      CONTRACT_NUM - Contract Number
      COURSE_LIST - Course List
      CRSE_ID - Course ID
      CUR_RT_TYPE - Exchange Rate Type
      CURRENCY_CD - Currency Code
      DEPOSIT_NBR - Deposit Nbr
      DISBURSEMENT_DATE - Disbursement Date
      DUE_DT - Due Date
      EMPLID - EmplID
      ENCUMBERED_AMT - Amount Encumbered
      EXT_ORG_ID - External Org ID
      FEDERAL_TAX_RT - Federal Tax Rate
      FEE_CD - Fee Code
      GL_ASSESSED_AMT - GL Assessed
      GL_BALANCED_AMT - GL Assessed
      GL_FROM_SUBFEE - GL from Sub Fees
      GL_SATISFIED_AMT - GL Satisfied Amount
      INTEREST_DT - Interest Date
      ITEM_AMT - Item Amount
      ITEM_BALANCE - Item Balance
      ITEM_EFFECTIVE_DT - Item Effective Date
      ITEM_NBR_SOURCE - Item Nbr - Src Charge Nbr
      ITEM_STATUS - Item Status
      ITEM_TERM - Item Term
      ITEM_TYPE - Item Type
      ITEM_TYPE_CD - Item Type Code
          A         Application Fee               App Fee
          B         Billing Only                  Billing
          C         Charge                        Charge
          D         Deposit                       Deposit
          F         Financial Aid                 Fin. Aid
          G         GL Interface Only             GL Only
          H         Withholding                   Withhold
          I         Interest                      Interest
          L         Pre-Paid Tuition              Pre-paid
          P         Payment                       Payment
          R         Refund                        Refund
          T         Transfers                     Transfers
          V         Contributor Relations         CR

07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
          W          Waiver                       Waiver
          X          Write-off                    Write-off
          Z          Pay Plan Credit              Credit
      LAST_ACTIVITY_DATE - Last Activity Date
      LATE_FEE_CODE - Late Fee Code
      LOCAL_TAX_RT - Local Tax Rate
      NRA_TAXATION_SWTCH - NRA Taxation Option
      ORIG_EFF_DT - Original Effective Date
      ORIGINAL_ACCT_TERM - Original Account Term
      ORIGNL_CURRENCY_CD - Currency Code
      ORIGNL_ITEM_AMT - Item Amount
      PAYMENT_ID_NBR - Payment ID Nbr
      PRIORITY - Priority
      PRIORITY_PMT_FLG - Payment Priority Flag
      RATE_DIV - Rate Divisor
      RATE_MULT - Rate Multiplier
      RECEIPT_NBR - Receipt Number
      REF1_DESCR - Reference Nbr
      REFUND_EMPLID - Refund ID
      REFUND_EXT_ORG_ID - Refund External Org ID
      REFUND_NBR - Refund Nbr
      REFUND_ORG_CONTACT - Refund Org Contact
      SEL_GROUP - Tuition Group
      SESSION_CODE - Session
      SF_ADM_APPL_DEL - Application Deleted
      SF_DEPOSIT_ID - Deposit ID
      SF_PMT_REF_NBR - Reference Nbr
      SRVC_IND_DTTM - Service Indicator Date Time
      STATE_TAX_RT - State Tax Rate
      STDNT_CAR_NBR - Student Career Nbr
      T4_SENT_AMT - T4 Sent Amt
      TAX_ADJ_WHOLDINGS - Gross Taxable Payments YTD
      TAX_AUTHORITY_CD - Tax Authority
      TAX_CD - Tax Code
      TRACER_NBR - Bank Tracer Nbr
      TRANS_FEE_CD - Transaction Fee Code
      TRANSFER_AMT - Transfer Amt
      TRANSFER_DT - Transfer Date
      TRANSFER_PAYMNT_ID - Transfer Payment ID
      TRANSFER_STATUS - Transfer Status
      WAIVER_CODE - Waiver Code

 ITEM_TYPE_1_TBL - Item Type Control Table
 Y    ITEM_TYPE - Item Type
 Y    SETID - SetID

 ITEM_TYPE_TBL - Item Type Table
 Y    EFFDT - Effective Date
 Y    ITEM_TYPE - Item Type
 Y    SETID - SetID
      ACCTG_DT_CNTL - Accounting Date Control

07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      ADJUSTMENT_CAL_SF - Adjustment Calendar
      ALL_OR_NONE - Pay All or None
      CHARGE_PRIORITY - Charge Priority List
      CURRENCY_CD - Currency Code
      DAYS_SINCE_EFFDT - Days Past Since Effdt
      DAYS_TO_EFFDT - Days to Effdt
      DEFAULT_AMT - Default Amount
      DESCR - Description
      DESCRSHORT - Short Description
      DUEDAYS_PAST_EFFDT - Nbr of Days Past Effdt
      DUEDAYS_PRIOR_EFFD - Nbr of Days Before Effdt
      EFF_STATUS - Status as of Effective Date
      ENCUMBRANCE_DAYS - Days to Encumber
      ENCUMBRANCE_PCT - Encumbrance Pct
      ENROL_FLAG - Enrolled Flag
      ERNCD - Earnings Code
      ERNCD_NOTAX - Earnings Code Non Taxable
      GL_CRSE_CLASS_SPC - Course Class Specific
      GL_INTERFACE_REQ - GL Interface Required
      ITEM_TYPE_CD - Item Type Code
      KEYWORD1 - Key Word
      KEYWORD2 - Key Word 2
      KEYWORD3 - Key Word 3
      LOCAL_TAX_OFFSET - Local Tax Offset
      LOCAL_TAX_PMT - Local Tax Payment
      MATCH_WRITEOFF - Match Charge Write-Offs
      MAXIMUM_AMT - Maximum Transaction Amount
      MINIMUM_AMT - Mininum Transaction Amount
      NRA_CREDIT_TAX_FLG - NRA Tax Payment Flag
      NRA_DEBIT_TAX_FLG - NRA Tax Type
      PAY_PRIORITY_ID - Payment Overall Priority
      PAYMENT_PRIORITY - Payment Priority
      PAYMENT_TERMS - Payment Terms
      PRIORITY - Priority
      PRIORITY_PMT_FLG - Payment Priority Flag
      RECVABLE_FROM_CHRG - Pick up Receivable from Charge
      REFUNDABLE_IND - Refundable Indicator
      SECURITY_GROUP - Security Group
      SF_1098_FLG - 1098-T Eligible
      SSF_DEST_TUT_TYPE - DEST Tuition Type
      SSF_STATE_FLAG - State
      STATE_TAX_OFFSET - State Tax Offset
      STATE_TAX_PMT - State Tax Payment
      T2202A_FLG - T2202A Eligible
      T2202A_OFFSET_FLG - T2202A Offset
      T2202A_PCT - T2202A Percent
      T4_INCOME - T4A Eligible
      TAX_CD - Tax Code
      TAXABLE_Y_N - Taxable
      TENDER_CATEGORY - Tender Category
      TENDER_SPEC - Tender Specific
      TERM_ENROLL_REQ - Term Enroll Req for Posting

07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      TUITION_DEPOSIT - Tuition Deposit
      WAGE_LOSS_PLAN - Wage Loss Replacement Plan

 ITEM_TYPE_VW - Item Type TBL View
      Y   SETID - SetID
      Y   ITEM_TYPE - Item Type
          DESCR - Description

 ITEM_XREF - Links Payments and Charges together by Item Nbr
 Y    BUSINESS_UNIT - Business Unit
 Y    COMMON_ID - ID
 Y    EFFDT - Effective Date
 Y    ITEM_NBR_CHARGE - Item Nbr Charge
 Y    ITEM_NBR_PAYMENT - Item Nbr Payment
 Y    SA_ID_TYPE - ID Type
      CONTRACT_NUM - Contract Number
      EFF_STATUS - Status as of Effective Date
      GL_ASSESSED_AMT - GL Assessed
      ITEM_NBR_CONTRACT - Item Number Contract
      PAYMENT_ID_NBR - Payment ID Nbr
      PRIORITY - Priority
      PRIORITY_PMT_FLG - Payment Priority Flag
      REFUND_NBR - Refund Nbr
      SF_PRIORITY - Contract Priority
      SF_REVERSAL_IND - Reversal Indicator
      WRITEOFF_FLG - Write Off Flag
      XREF_AMT - Item Cross Reference Amount
      XREF_STATUS - Xref Status

 ITEM_XREF_VW - Links Payments and Charges together by Emplid by Item Nbr
 Y    BUSINESS_UNIT - Business Unit
 Y    EMPLID - EmplID
 Y    ITEM_NBR - Item Nbr
      ACCOUNT_NBR - Account Nbr
      ACCOUNT_TERM - Account Term
      COMMON_ID - ID
      CONTRACT_NUM - Contract Number
      ITEM_AMT - Item Amount
      ITEM_NBR_CHARGE - Item Nbr Charge
      ITEM_NBR_PAYMENT - Item Nbr Payment
      ITEM_TERM - Item Term
      ITEM_TYPE - Item Type
      ITEM_TYPE_CD - Item Type Code
      PAYMENT_ID_NBR - Payment ID Nbr
      SA_ID_TYPE - ID Type
      SF_REVERSAL_IND - Reversal Indicator
      XREF_AMT - Item Cross Reference Amount
      XREF_DT - Item Cross Reference Date
      XREF_STATUS - Xref Status

 PERSON_NAME - Current Primary Name View

07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
 Y    EMPLID - EmplID
      ASOFDATE - As Of Date
      COUNTRY_NM_FORMAT - Format Using
      FIRST_NAME - First Name
      FIRST_NAME_SRCH - First Name
      LAST_NAME - Last Name
      LAST_NAME_PREF_NLD - Last Name Preference
      LAST_NAME_SRCH - Last Name
      MIDDLE_NAME - Middle Name
      NAME - Name
      NAME_AC - Alternate Character Name
      NAME_DISPLAY - Display Name
      NAME_FORMAL - Formal Name
      NAME_INITIALS - Name Initials
      NAME_PREFIX - Name Prefix
      NAME_PSFORMAT - Name (LN,FN)
      NAME_ROYAL_PREFIX - Name Royal Prefix
      NAME_ROYAL_SUFFIX - Name Royal Suffix
      NAME_SUFFIX - Name Suffix
      NAME_TITLE - Title
      NAME_TYPE - Type of Name
      PARTNER_LAST_NAME - Last Name Partner
      PARTNER_ROY_PREFIX - Prefix Partner
      PREF_FIRST_NAME - Preferred First Name
      SECOND_LAST_NAME - Second Last Name
      SECOND_LAST_SRCH - Second Name

 REFUND_DTL - Refund Detail
 Y    BUSINESS_UNIT - Business Unit
 Y    LINE_SEQ_NBR - Line Sequence Nbr
 Y    REFUND_NBR - Refund Nbr
      EMPLID - EmplID
      ERNCD - Earnings Code
      EXT_ORG_ID - External Org ID
      ITEM_NBR - Item Nbr
      LINE_AMT - Line Amount
      REFUND_EMPLID - Refund ID
      REFUND_FORMAT - Refund Format
      REFUND_LINE_STATUS - Refund Line Status
      REFUND_LINE_TYPE - Refund Line Type
      SEQNO - Sequence Number

 REFUND_HDR - Refund Header Record
 Y    BUSINESS_UNIT - Business Unit
 Y    REFUND_NBR - Refund Nbr
      ADDR_FIELD1 - Address Field 1
      ADDR_FIELD2 - Address Field 2
      ADDR_FIELD3 - Address Field 3
      ADDRESS_TYPE - Address Type
      ADDRESS1 - Address Line 1
      ADDRESS2 - Address Line 2

07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      ADDRESS3 - Address Line 3
      ADDRESS4 - Address Line 4
      APPROVAL_DATETIME - Datetime Approval
      APPROVAL_OPRID - Operator ID Approval
      BATCH_ID - Batch ID
      BATCH_ID_CC - ePayment Batch ID
      CITY - City
      COMPANY - Company
      COUNTRY - Country
      COUNTY - County
      CURRENCY_CD - Currency Code
      EMPL_RCD - Empl Rcd Nbr
      EMPLID - ID
      ERNCD - Earnings Code
      EXT_CHECK - External Check Number
      EXT_CHECK_NET - External Check Net
      EXT_ORG_ID - External Org ID
      EXTRA_ACCOUNT_NBR - Extra Account Nbr
      EXTRA_ACCT_TERM - Extra Account Term
      EXTRA_ITEM_TERM - Extra Item Term
      EXTRA_REFUND_AMT - Extra Refund Amount
      GEO_CODE - Tax Vendor Geographical Code
      HOUSE_TYPE - House Type
      IN_CITY_LIMIT - In City Limit
      ITEM_TYPE - Item Type
      LINE_NUM - Line #
      NUM1 - Number 1
      NUM2 - Number 2
      OPRID - User ID
      PAGE_NUM - Page #
      PAY_END_DT - Pay Period End Date
      PAYGROUP - Pay Group
      POSTAL - Postal Code
      PROCESS_INSTANCE - Process Instance
      PROCESS_NAME - Process Name
      REF_APPR_ACTIVE_SW - Activate On-line Approvals
      REF_APPR_DATE_1 - Approval Date Time 1
      REF_APPR_DATE_2 - Approval Data Time 2
      REF_APPR_DATE_3 - Approval Data Time 3
      REF_APPR_OPR_1 - Approval OPRID 1
      REF_APPR_OPR_2 - Approval OPRID 2
      REF_APPR_OPR_3 - Approval OPRID 3
      REF_APPR_SW_1 - Approval Switch 1
      REF_APPR_SW_2 - Approval Switch 2
      REF_APPR_SW_3 - Approval Switch 3
      REFUND_AMT - Refund Amount
      REFUND_DTTM - Refund Date and Time
      REFUND_EMPLID - Refund ID
      REFUND_EXT_ORG_ID - Refund External Org ID
      REFUND_METHODE - Refund Method
      REFUND_STATUS - Refund Status
      REFUND_TYPE - Refund Type

07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      SSF_REFUND_ERROR - Error Code
      STATE - State
      VOUCHER_ID - Voucher ID

 SF_ACCTG_LN - SF Accounting Line
 Y    RUN_DT - Run Date
 Y    SEQNUM - Sequence number
 Y    SF_LINE_NBR - Line Number
      ACCOUNT - Account
      ACCOUNTING_DT - Accounting Date
      ACCOUNTING_PERIOD - Accounting Period
      AFFILIATE - Affiliate
      AFFILIATE_INTRA1 - Fund Affiliate
      AFFILIATE_INTRA2 - Operating Unit Affiliate
      ALTACCT - Alternate Account
      APPL_JRNL_ID - Journal Template
      AUDIT_ACTN - Action
      BUDGET_PERIOD - Budget Period
      BUDGET_REF - Budget Reference
      BUSINESS_UNIT - Business Unit
      BUSINESS_UNIT_GL - General Ledger Unit
      CHARTFIELD1 - Chartfield 1
      CHARTFIELD2 - Chartfield 2
      CHARTFIELD3 - Chartfield 3
      CLASS_FLD - Class Field
      COMMON_ID - ID
      CURRENCY_CD - Currency Code
      DEPTID - Department
      EMPLID - EmplID
      EXT_GL_CHARTFLD - External GL Chart Field
      FISCAL_YEAR - Fiscal Year
      FOREIGN_AMOUNT - Foreign Amount
      FOREIGN_CURRENCY - Foreign Currency Code
      FUND_CODE - Fund Code
      GL_DISTRIB_STATUS - Distribution Status
      IN_PROCESS_FLG - In Process
      ITEM_NBR - Item Nbr
      JOURNAL_DATE - Journal Date
      JOURNAL_ID - GL Journal ID
      JOURNAL_LINE - GL Journal Line Number
      JOURNAL_LINE_DATE - Journal Line Date
      JRNL_LINE_STATUS - Journal Line Status
      JRNL_LN_REF - Journal Line Reference
      LEDGER - Ledger
      LEDGER_GROUP - Ledger Group
      LINE_DESCR - Journal Line Description
      MONETARY_AMOUNT - Monetary Amount
      OPEN_ITEM_STATUS - Open Item Status
      OPERATING_UNIT - Operating Unit
      PROCESS_INSTANCE - Process Instance
      PRODUCT - Product


07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      PROGRAM_CODE - Program Code
      PROJECT_ID - Project/Grant
      RATE_DIV - Rate Divisor
      RATE_MULT - Rate Multiplier
      RT_TYPE - Rate Type
      SA_ID_TYPE - ID Type
      SF_DEPOSIT_ID - Deposit ID
      SF_EXT_ORG_ID - External Org ID
      SF_GL_RUN_INSTANCE - Process Instance
      STATISTIC_AMOUNT - Statistic Amount
      STATISTICS_CODE - Statistics Code

 SRVC_IND_DATA - Service Indicator Data
 Y    EMPLID - EmplID
 Y    SRVC_IND_DTTM - Service Indicator Date Time
      AMOUNT - Amount
      COMM_COMMENTS - Comments
      CONTACT - Contact Person
      CONTACT_ID - Contact ID
      CURRENCY_CD - Currency Code
      DEPTID - Department
      INSTITUTION - Academic Institution
      OPRID - User ID
      PLACED_METHOD - Placed Method
      PLACED_PERSON - Service Ind Placed Person
      PLACED_PERSON_ID - Placed Person ID
      PLACED_PROCESS - Placed Process Name
      POS_SRVC_INDICATOR - Positive Service Indicator
      POSITION_NBR - Position Number
      RELEASE_PROCESS - Release Process Name
      SEQ_3C - Sequence Number
      SRVC_IND_ACT_TERM - Service Ind Active Term
      SRVC_IND_ACTIVE_DT - Service Indicator Active Date
      SRVC_IND_CD - Service Indicator Cd
      SRVC_IND_REASON - Service Ind Reason Code
      SRVC_IND_REFRNCE - Service Indicator Reference

 STDNT_CAR_TERM - Student Career Term Table
 Y    ACAD_CAREER - Academic Career
 Y    EMPLID - EmplID
 Y    INSTITUTION - Academic Institution
 Y    STRM - Term
      ACAD_CAREER_FIRST - First Time in Career
      ACAD_GROUP_ADVIS - Academic Group of Advisor
      ACAD_LEVEL_BOT - Academic Level - Term Start
      ACAD_LEVEL_EOT - Academic Level - Term End
      ACAD_LEVEL_PROJ - Academic Level - Projected
      ACAD_LOAD_APPR - Approved Academic Load
      ACAD_PROG_PRIMARY - Primary Academic Program
      ACAD_YEAR - Academic Year
      ACADEMIC_LOAD - Academic Load

07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      ACADEMIC_LOAD_DT - Academic Load Change Date
      BILLING_CAREER - Billing Career
      CLASS_RANK_NBR - Class Rank Nbr
      CLASS_RANK_TOT - Class Rank Total
      COUNTRY - Country
      CUM_GPA - Cumulative GPA
      CUM_RESIDENT_TERMS - Cumulative In Residence Terms
      CUR_GPA - Current GPA
      CUR_RESIDENT_TERMS - Current In Residence Terms
      ELIG_TO_ENROLL - Eligible to Enroll
      END_DATE - End Date
      ENRL_ON_TRANS_DT - Show Enrollment on Transcript
      EXT_ORG_ID - External Org ID
      FA_ELIGIBILITY - Program Eligibility Flag
      FA_LOAD - Financial Aid Load
      FA_STATS_CALC_DTTM - FA Stats Calc Date Time
      FA_STATS_CALC_REQ - FA Stats Calculation Required
      FORM_OF_STUDY - Form of Study
      FULLY_ENRL_DT - Fully Enrolled Date
      FULLY_GRADED_DT - Fully Graded Date
      GRADE_POINTS - Grade Points
      GRADE_POINTS_FA - Financial Aid Grade Points
      LAST_DATE_ATTENDED - Last Date of Attendance
      LOCK_IN_AMT - Lock In Amount
      LOCK_IN_DT - Lock In Date
      MAX_AUDIT_UNIT - Max Audit Units
      MAX_CRSE_COUNT - Max Total Courses
      MAX_NOGPA_UNIT - Max No GPA Units
      MAX_TOTAL_UNIT - Max Total Units
      MAX_WAIT_UNIT - Max Wait List Units
      MIN_TOTAL_UNIT - Min Total Units
      NSLDS_LOAN_YEAR - NSLDS Loan Year
      OVRD_ACAD_LVL_ALL - Override All Academic Levels
      OVRD_ACAD_LVL_PROJ - Override Projected Level
      OVRD_BILL_UNITS - Override Billing Units
      OVRD_INIT_ADD_FEE - Override Initial Add Fees
      OVRD_INIT_ENR_FEE - Override Initial Enroll Fee
      OVRD_MAX_UNITS - Override Maximum Units
      OVRD_TUIT_GROUP - Override Tuition Group
      OVRD_WDRW_SCHED - Override Withdrawal Schedule
      PRO_RATA_ELIGIBLE - Pro-Rata Eligible
      PROJ_BILL_UNT - Projected Bill Units
      REFUND_PCT - Refund Percentage
      REFUND_SCHEME - Refund Scheme
      REG_CARD_DATE - Registration Card Date
      REGISTERED - Registered
      RESET_CUM_STATS - Reset Cum Stats at Term Start
      SEL_GROUP - Tuition Group
      SSR_ACTIVATION_DT - Term Activation Date
      START_DATE - Start Date for Gen Standing PO
      STATS_ON_TRANS_DT - Show Statistics on Transcript
      STDNT_CAR_NBR - Student Career Nbr

07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      STUDY_AGREEMENT - Study Agreement
      TC_UNITS_ADJUST - TC Units Adjustment
      TERM_TYPE - Term Unit Type
      TOT_AUDIT - Total Audited
      TOT_CUMULATIVE - Total Cumulative Units
      TOT_GRADE_POINTS - Total Grade Points
      TOT_GRD_POINTS_FA - Total Fin Aid Grade Points
      TOT_INPROG_GPA - Total In Progress - GPA
      TOT_INPROG_NOGPA - Total In Progress -Not for GPA
      TOT_OTHER - Total from Other Credit
      TOT_PASSD_FA - Total Fin Aid Units Passed
      TOT_PASSD_GPA - Total Passed Toward GPA
      TOT_PASSD_NOGPA - Total Passed Not Toward GPA
      TOT_PASSD_PRGRSS - Total Passed for Progress
      TOT_TAKEN_FA - Total Fin Aid Units Taken
      TOT_TAKEN_FA_GPA - Total Fin Aid Taken Toward GPA
      TOT_TAKEN_GPA - Total Taken Toward GPA
      TOT_TAKEN_NOGPA - Total Taken Not Toward GPA
      TOT_TAKEN_PRGRSS - Total Taken for Progress
      TOT_TEST_CREDIT - Total From Test Credit
      TOT_TRNSFR - Total Transferred
      TRF_GRADE_POINTS - Transfer Grade Points
      TRF_PASSED_GPA - Transfer Passed for GPA
      TRF_PASSED_NOGPA - Transfer Passed Not for GPA
      TRF_RESIDENT_TERMS - Transfer In Residence Terms
      TRF_TAKEN_GPA - Transfer Taken for GPA
      TRF_TAKEN_NOGPA - Transfer Taken Not for GPA
      TUIT_CALC_DTTM - Tuit Calc Date Time
      TUIT_CALC_REQ - Tuition Calc Required
      TUITION_RES_TERMS - Tuition Residency
      UNIT_MULTIPLIER - Unit Multiplier
      UNT_AUDIT - Units Audited
      UNT_INPROG_GPA - Units In Progress - GPA
      UNT_INPROG_NOGPA - Unit In Progress - Not for GPA
      UNT_OTHER - Units from Other Credit
      UNT_PASSD_FA - Fin Aid Progress Units Passed
      UNT_PASSD_GPA - Units Passed Toward GPA
      UNT_PASSD_NOGPA - Units Passed Not Toward GPA
      UNT_PASSD_PRGRSS - Units Passed for Progress
      UNT_TAKEN_FA - Fin Aid Progress Units Taken
      UNT_TAKEN_FA_GPA - FA Units Taken Toward GPA
      UNT_TAKEN_GPA - Units Taken Toward GPA
      UNT_TAKEN_NOGPA - Units Taken Not Toward GPA
      UNT_TAKEN_PRGRSS - Units Taken for Progress
      UNT_TERM_TOT - Total Term Units
      UNT_TEST_CREDIT - Units from Test Credit
      UNT_TRNSFR - Units Transferred
      UNTPRG_CHG_NSLC_DT - Unit Progrss Changed Date NSC
      WITHDRAW_CODE - Withdrawal \ Cancel
      WITHDRAW_DATE - Withdrawal \ Cancel Date
      WITHDRAW_REASON - Withdrawal \ Cancel Reason



07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
 STDNT_ENRL - Student Enrollment Table
 Y    ACAD_CAREER - Academic Career
 Y    CLASS_NBR - Class Nbr
 Y    EMPLID - EmplID
 Y    INSTITUTION - Academic Institution
 Y    STRM - Term
      ACAD_PROG - Academic Program
      ASSOCIATED_CLASS - Associated Class
      ASSOCIATION_99 - Association 99
      AUDIT_GRADE_BASIS - Audit Grading Basis
      CLASS_PRMSN_NBR - Class Permission Nbr
      CRSE_CAREER - Course Career
      CRSE_COUNT - Course Count
      CRSE_GRADE_INPUT - Grade Input
      CRSE_GRADE_OFF - Official Grade
      DROP_CLASS_IF_ENRL - Drop This Class if Enrolled
      DYN_CLASS_NBR - Dynamic Class Nbr
      EARN_CREDIT - Earn Credit
      ENRL_ACTION_LAST - Last Enrollment Action
      ENRL_ACTN_PRC_LAST - Last Enrollment Action Process
      ENRL_ACTN_RSN_LAST - Last Enrl Action Reason
      ENRL_ADD_DT - Enrollment Add Date
      ENRL_DROP_DT - Enrollment Drop Date
      ENRL_REQ_SOURCE - Enrollment Request Source
      ENRL_STATUS_REASON - Enrollment Status Reason
      GRADE_CATEGORY - Grade Category
      GRADE_DT - Grade Date
      GRADE_POINTS - Grade Points
      GRADE_POINTS_FA - Financial Aid Grade Points
      GRADING_BASIS_DT - Grading Basis Date
      GRADING_BASIS_ENRL - Grading Basis
      GRADING_SCHEME_ENR - Field is not active yet
      GRD_PTS_PER_UNIT - Grade Points Per Unit
      INCLUDE_IN_GPA - Include in GPA
      INSTRUCTOR_ID - Instructor ID
      LAST_DROP_DT_STMP - Last Drop Date Stamp
      LAST_DROP_TM_STMP - Last Drop Time Stamp
      LAST_ENRL_DT_STMP - Last Enrollment Date Stamp
      LAST_ENRL_TM_STMP - Last Enrollment Time Stamp
      LAST_UPD_DT_STMP - Last Update Date Stamp
      LAST_UPD_ENREQ_SRC - Enrollment Request Source
      LAST_UPD_TM_STMP - Last Update Time Stamp
      MANDATORY_GRD_BAS - Mandatory Grading Basis
      NOTIFY_STDNT_CHNG - Notify Student of Change
      OPRID - User ID
      OVRD_GRADING_BASIS - Override Grading Basis
      RELATE_CLASS_NBR_1 - Field is not active yet
      RELATE_CLASS_NBR_2 - Field is not active yet
      REPEAT_CANDIDATE - Repeat Candidate Flag
      REPEAT_CODE - Repeat Code
      REPEAT_DT - Repeat Date
      RQMNT_DESIGNTN - Requirement Designation

07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      RQMNT_DESIGNTN_GRD - Requirement Designation Grade
      RQMNT_DESIGNTN_OPT - Requirement Designation Option
      RSRV_CAP_NBR - Reserve Capacity Sequence
      SEL_GROUP - Tuition Group
      SESSION_CODE - Session
      SESSN_ENRL_CNTL - Enrollment Control Session
      STATUS_DT - Status Date
      STDNT_ENRL_STATUS - Student Enrollment Status
      STDNT_POSITIN - Student Position
      TSCRPT_NOTE_EXISTS - Transcript Note Exists Flag
      TSCRPT_NOTE_ID - Transcript Note ID
      UNITS_ATTEMPTED - Units Attempted
      UNT_BILLING - Billing Units
      UNT_EARNED - Units Earned
      UNT_PRGRSS - Units Taken-Academic Progress
      UNT_PRGRSS_FA - Units Taken-Fin Aid Progress
      UNT_TAKEN - Units Taken
      VALID_ATTEMPT - Valid Attempted Grade

 STDNT_GRPS_HIST - Student Groups by Emplid
 Y    EFFDT - Effective Date
 Y    EMPLID - EmplID
 Y    INSTITUTION - Academic Institution
 Y    STDNT_GROUP - Student Group
      COMMENTS - Comment
      EFF_STATUS - Status as of Effective Date

 TERM_FEE_TBL - Term Fee Table
 Y    FEE_CODE - Fee Code
 Y    SESSION_CODE - Session
 Y    SETID - SetID
 Y    STRM - Term
      ACCOUNT_TYPE_SF - Account Type
      ADJ_TERM_CD - Adjustment Code
      ANTIC_ITEM_TYPE - Anticipated Item Type
      AUDIT_CALC_FLAG - Audit calculated separately
      AUDIT_RT_FLAG - Audit Rate specified
      CHARGE_WAIT_LIST - Charge for Wait Listed Class
      CURRENCY_CD - Currency Code
      DUE_DATE_CODE - Due Date Code
      DYNAMIC_ORG - Dynamic Organization
      FEE_TRIGGER - Fee Trigger
      GL_FROM_SUBFEE - GL from Sub Fees
      ITEM_TYPE - Item Type
      MAX_AMOUNT - Maximum Amount
      MIN_AMOUNT - Minimum Amount
      MIN_MAX_FEE_CODE - Min/Max Fee Code
      SSF_CRITR_EQUTN_SW - Criteria / Equation
      SSF_EXCLUDE_HECS - Exclude Classes w/ HECS Status
      TRACK_CLASS_PRICE - Track Class pricing
      TRACK_SUB_FEE - Track Sub Fees

07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      USE_ANTIC_STOP_DT - Use Anticipated Unit Stop Date

 TERM_SUBFEE_TBL - Term Sub Fee Table
 Y    ACAD_CAREER - Academic Career
 Y    ACAD_GROUP - Academic Group
 Y    ACAD_PROG - Academic Program
 Y    CAMPUS - Campus
 Y    FEE_CODE - Fee Code
 Y    INSTITUTION - Academic Institution
 Y    INSTRUCTION_MODE - Instruction Mode
 Y    LOCATION - Location Code
 Y    SESSION_CODE - Session
 Y    SETID - SetID
 Y    SSR_COHORT_YR - Cohort Year
 Y    STRM - Term
 Y    SUB_FEE_CODE - Sub Fee Code
 Y    SUBJECT - Subject Area
 Y    UNIT_FROM - Unit From
 Y    UNIT_TO - Unit To
      AMT_PER_UNIT - Amount Per Unit
      AMT_PER_UNIT_AUDIT - Amt / Unit (Audit)
      AMT_PER_UNIT_SRCHG - Amt / Unit (Surcharge)
      CURRENCY_CD - Currency Code
      EQUATION_NAME - Equation Name
      FLAT_AMT - Flat Amount
      FLAT_AMT_AUDIT - Flat Amt (Audit)
      FLAT_AMT_SRCHG - Flat Amt (Surcharge)
      ITEM_TYPE - Item Type
      SURCHARGE_EFF_UNIT - Surcharge Effective Unit

 TP_CONTRACT - Third Party Contracts
 Y    BUSINESS_UNIT - Business Unit
 Y    CONTRACT_NUM - Contract Number
      ACAD_YEAR - Academic Year
      ACCOUNT_TYPE_SF - Account Type
      ADD_CHRGS_DT - Charge Add Date
      ADD_OFF_DT - Offset Add Chrg Date
      ADJ_CHRGS_DT - Charge Adjust Date
      ADJ_OFF_DT - Offset Adjust Chrg Date
      ANTIC_AID_DT - Antic Aid DT
      ANTIC_AID_TERM_TO - Antic Aid Term To
      ANTIC_AID_TRM_FROM - Antic Aid Term From
      CALC_REAL_TIME_FLG - Calc. Real Time Flag
      CLASS_NBR - Class Nbr
      COLLECTION_ID - Collection ID
      COURSE_LIST - Course List
      CREDIT_ITEM_TYPE - Credit Item Type
      CURRENCY_CD - Currency Code
      DAY_OF_MONTH - Day of the Month
      DEDCD - Deduction Code
      DEFER_DAYS_ADJ - Defer Days Adjustments

07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      DEFER_DAYS_CHRG - Defer Days Charges
      DEFER_DT_ADJ - Defer Date Adjustments
      DEFER_DT_CHRG - Defer Date Charges
      DEFICIT_AMT - Deficit Amount
      DEFICIT_FLG - Deficit Flag
      DELIVER_CODE - Delivery Code
      DESCR - Description
      DESCR1 - Descr
      DESCR254 - Long Description
      DESCRSHORT - Short Description
      DUE_DT - Expected Birth Date
      END_DT - End Date
      EXT_ORG_ID - External Org ID
      EXTRA_PAY_OPT - Extra Payments Option
      GEN_TRANSFER_ITEM - Generate Transfer Item
      GUESS_AMT - Guess Amt
      GUESS_AMT_EXPIR_DT - Guess Amt Exp. DT
      GUST_AMT_ITEM_TYPE - Guess Amount Item type
      INTEREST_CALC_MTHD - Interest Calculation Method
      INTEREST_ITEM_TYPE - Interest Item Type
      INTEREST_RATE - Interest Rate
      ITEM_TYPE - Item Type
      ITEM_TYPE_GROUP - Item Type Group
      ITEM_TYPE_GRP_OFF - Offset Item Type Group
      LAST_DT_DEF_ADJ - Last Date to Defer Adjustments
      LAST_DT_DEF_CHRG - Last Date to Defer Charges
      LUMP_SUM_AMT - Lump Sum Amt
      MAX_AMT - Maximum Amount
      MAX_TERM_AMT - Max Term Amount
      MONTHCD - Month
      ORG_CODE - Organization Code
      ORG_CONTACT - Contact Nbr
      PAY_PLAN_TYPE - Payment Plan Type
      PLAN_TYPE - Plan Type
      PLAN_TYPE_SF - Plan Type
      PMT_ITEM_TYPE - Payment Item Type
      REQUISITION_NBR - Requisition Number
      SF_PRIORITY - Contract Priority
      START_DT - Start Date
      STRM - Term
      TERM_FROM - Term From
      TERM_FROM_OFF - Offset Term From
      TERM_TO - Term To
      TERM_TO_OFF - Offset Term To
      TOT_DEFER_AMT - Total Amount to Defer
      TP_ADJ_OPTION - Adjustment Option
      TP_ASSESS_AMT - Assessment Fee
      TP_ASSESS_FEE_SPLT - Assessment Fee Split
      TP_ASSESS_FLAT_PER - Assessment Flat Percentage
      TP_ASSESS_ITEM_TYP - Assessment Item Type
      TP_ASSESS_MNTH_INT - Assessment Monthly Interest
      TP_ASSESS_TYPE - Assessment Type

07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      TP_CAP_CONTRACT - Contract Max
      TP_CAP_STUDENT - Third Party Student Maximum
      TP_CON_ACCT_TYPE - Administrative Account Type
      TP_CON_BILL_CYCLE - Billing Cycle
      TP_CON_BILL_DT - First Billing Date
      TP_CON_BILL_ITMTPY - Billing Item Type
      TP_CON_CURR_AID_YR - Current Aid Year
      TP_CON_DATE_TYPE - Contract Date Types
      TP_CON_EXT_CON_NUM - External Contract Number
      TP_CON_LAST_COR_DT - Last Date to Enter Corrections
      TP_CON_NUM_PAYMENT - Number Of Payments
      TP_CON_PAY_CHARGE - Payment Charge
      TP_CON_PAY_CRE_TYP - Credit Account Type
      TP_CON_PAY_CREDIT - Payment Credit
      TP_CON_PLAN_FEE - Plan Fee Amount
      TP_CON_PRI_AID_YR - Prior Aid Year
      TP_CON_TYPE - Third Party Contract Type
      TP_CONTRACT_TYPE - Third Party Contract Type
      TP_DISC_ITEM_TYPE - Discount Item Type
      TP_DUE_DATE_DAYS - Payment Due Days
      TP_EXT_CONTRACT - External Contract Number
      TP_MAX_AMOUNT - Max Amount
      TP_STATUS - Contract Status
      TRANSFER_ITEM_TYPE - Transfer Item Type
      TRANSFER_NBR - Number to Transfer
      TREE_NAME - Tree Name
      USE_DUE_DATE - Use Date
      USE_DUE_DATE2 - Use Date
      USE_DUE_DATE3 - Use Date

 TP_STUDENT - Third Party Student
 Y    BUSINESS_UNIT - Business Unit
 Y    CONTRACT_NUM - Contract Number
 Y    TP_SEQ_NBR - TP Sequence Number
      ADD_CHRGS_DT - Charge Add Date
      ADD_OFF_DT - Offset Add Chrg Date
      ADJ_CHRGS_DT - Charge Adjust Date
      ADJ_OFF_DT - Offset Adjust Chrg Date
      ANTIC_AID_DT - Antic Aid DT
      ANTIC_AID_TERM_TO - Antic Aid Term To
      ANTIC_AID_TRM_FROM - Antic Aid Term From
      BACKDATE_DT - Back Date
      CALC_REAL_TIME_FLG - Calc. Real Time Flag
      COURSE_LIST - Course List
      DEFICIT_AMT - Deficit Amount
      DEFICIT_FLG - Deficit Flag
      EMPLID - EmplID
      EXTRA_PAY_OPT - Extra Payments Option
      GEN_TRANSFER_ITEM - Generate Transfer Item
      GUESS_AMT - Guess Amt
      GUESS_AMT_EXPIR_DT - Guess Amt Exp. DT


07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      ITEM_NBR_PAYMENT - Item Nbr Payment
      ITEM_TYPE_GROUP - Item Type Group
      ITEM_TYPE_GRP_OFF - Offset Item Type Group
      LAST_DT_DEF_ADJ - Last Date to Defer Adjustments
      LAST_DT_DEF_CHRG - Last Date to Defer Charges
      LUMP_SUM_AMT - Lump Sum Amt
      MAX_AMT - Maximum Amount
      PAYMENT_ID_NBR - Payment ID Nbr
      PLAN_TYPE_SF - Plan Type
      PMT_ID_NBR_GUSTYPE - Payment ID Nbr
      PRE_EST_FA_AMT - Estimated Financial Aid
      PRE_OVERRIDE_AMT - Override Tuition Amount
      PRE_PLAN_AMT - Pre-Payment Plan Amount
      PROJ_TUIT_AMT - Projected Tuition Amount
      REF1_DESCR - Reference Nbr
      REFUND_EMPLID - Refund ID
      SF_PRIORITY - Contract Priority
      SPONSOR_EMPLID - Sponsor EmplID
      TERM_FROM - Term From
      TERM_FROM_OFF - Offset Term From
      TERM_TO - Term To
      TERM_TO_OFF - Offset Term To
      TOT_DEFER_AMT - Total Amount to Defer
      TP_ADJ_OPTION - Adjustment Option
      TP_ASSESS_WAIV_IND - Assessment Fee Waive Indicator
      TP_CAP_STUDENT - Third Party Student Maximum
      TP_CON_BILL_DT - First Billing Date
      TP_CON_NUM_PAYMENT - Number Of Payments
      TP_CON_PAY_CREDIT - Payment Credit
      TP_MAX_AMOUNT - Max Amount
      TP_POST_STATUS - Pre Payment Post Status
      TP_STATUS - Contract Status
      TRANSFER_ITEM_TYPE - Transfer Item Type
      TRANSFER_NBR - Number to Transfer

 TUIT_CALC_TBL - Tuition Calc Table
 Y    ACCOUNT_NBR - Account Nbr
 Y    BILLING_CAREER - Billing Career
 Y    BUSINESS_UNIT - Business Unit
 Y    EMPLID - ID
 Y    ITEM_TYPE - Item Type
 Y    LINE_SEQ_NBR - Line Sequence Nbr
 Y    STRM - Term
      ACAD_CAREER - Academic Career
      ACAD_PROG - Academic Program
      ACAD_YEAR - Academic Year
      ACCOUNT_TYPE_SF - Account Type
      ADJ_TERM_CD - Adjustment Code
      ADJUST_REASON - Adjust Reason
      CHARGE_BY - Charge By
      CHRG_ACCOUNT_NBR - Charge Account Nbr


07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      CHRG_ACCOUNT_TERM - Charge Account Term
      CHRG_ACCOUNT_TYPE - Charge Account Type
      CHRG_APPLIED_AMT - Charge Applied Amount
      CHRG_ITEM_AMT - Charge Item Amount
      CHRG_ITEM_NBR - Charge Item Nbr
      CHRG_ITEM_TYPE - Charge Item Type
      CHRG_REF1_DESCR - Charge Reference Nbr
      CLASS_CRSE_FEE_IND - Class/Course Fee Indicator
      CLASS_NBR - Class Nbr
      CLASS_PRICE_DTTM - Class Price Date Time
      COURSE_LIST - Course List
      CRSE_ID - Course ID
      CURRENCY_CD - Currency Code
      DUE_BY_CLASS_START - Due by Class Start Date Ind
      DUE_DATE_CODE - Due Date Code
      EXC_ACCT_TYPE_FLG - Excess Account Type Flag
      FEE_CD - Fee Code
      GL_FROM_SUBFEE - GL from Sub Fees
      INSTITUTION - Academic Institution
      ITEM_TYPE_CD - Item Type Code
      PRE_POST_AMT - Pre-Posting Amount
      REFUND_PCT - Refund Percentage
      SEL_GROUP - Tuition Group
      SESSION_CODE - Session
      SIGN_PRE_POST_AMT - Signed Pre Post Amount
      SRVC_IND_CD - Service Indicator Cd
      SRVC_IND_REASON - Service Ind Reason Code
      STDNT_CAR_NBR - Student Career Nbr
      TAX_AUTHORITY_CD - Tax Authority
      TRACK_CLASS_PRICE - Track Class pricing
      TRACK_SUB_FEE - Track Sub Fees
      TRANS_FEE_CD - Transaction Fee Code
      WAIVER_CODE - Waiver Code
      WAIVER_GROUP - Waiver Group




07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
Fields Included in Each Potentially Useful Student Records View and Table

     ACAD_CAR_TBL - Academic Career Table
     Y    ACAD_CAREER - Academic Career
     Y    EFFDT - Effective Date
     Y    INSTITUTION - Academic Institution
          ACAD_PLAN_TYPE - Academic Plan Type
          ADVISOR_EDIT - Advisor Edit
          DESCR - Description
          DESCRSHORT - Short Description
          DYN_CLASS_DATA - Dynamic Class Data Rule
          EFF_STATUS - Status as of Effective Date
          FA_CAR_TYPE - Financial Aid Career Type
          FA_PRIMACY_NBR - Primacy Nbr
          GRADE_TRANSFER - Default Grade- Transfer Credit
          GRADING_BASIS - Grading Basis
          GRADING_SCHEME - Grading Scheme
          GRADUATE_LVL_IND - Graduate Level
          HOLIDAY_SCHEDULE - Holiday Schedule
          LST_TRM_HIST_ENRL - Last Term for Hist Enrl Data
          OEE_DYN_DATE_RULE - OEE Dynamic Date Rule
          OEE_IND - Allow OEE Enrollment
          REPEAT_CRSE_ERROR - Course Catalog Repeat Message
          REPEAT_ENRL_CTL - Process on Enrollment
          REPEAT_ENRL_SUSP - Temp Susp Rpt Ck on Enrl
          REPEAT_GRD_CK - Repeat Grade Check
          REPEAT_GRD_SUSP - Temp Susp Rpt Ck on Grading
          REPEAT_RULE - Repeat Rule
          REPEAT_SCHEME - Repeat Scheme
          SAA_DISPLAY_OPTION - AA Oprid Display Option
          SF_GRAD_DESIGNATIO - Grad Designation
          SS_ENRL_APPT_CHKPT - Self Service Enrl Appt Edit
          SSR_ALLOW_PROG_IN - Allow Student to Select
          SSR_DFLT_TRMAC_LST - Default for Term Activation
          TERM_TYPE - Term Unit Type
          USE_DYN_CLASS_DATE - Use Dynamic Class Dates

     ACAD_GROUP_TBL - Academic Group Table
     Y    ACAD_GROUP - Academic Group
     Y    EFFDT - Effective Date
     Y    INSTITUTION - Academic Institution
          AUTO_ENRL_WAITLIST - Auto Enroll from Wait List
          DESCR - Description
          DESCRSHORT - Short Description
          EFF_STATUS - Status as of Effective Date
          STDNT_SPEC_PERM - Student Specific Permissions

     ACAD_LEVEL_TBL - Academic Level Table
     Y    ACADEMIC_LEVEL - Academic Level
     Y    EFFDT - Effective Date


    07/07/2008
    D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
 Y    LEVEL_LOAD_RULE - Academic Level Rule
 Y    SETID - SetID
 Y    UNT_CUM_TOTAL - Cum Units/Terms
      DIR_LND_YR - Direct Lending Year
      NSLDS_LOAN_YEAR - NSLDS Loan Year

 ACAD_PLAN - Student Academic Plan Table
 Y    ACAD_CAREER - Academic Career
 Y    ACAD_PLAN - Academic Plan
 Y    EFFDT - Effective Date
 Y    EFFSEQ - Effective Sequence
 Y    EMPLID - EmplID
 Y    STDNT_CAR_NBR - Student Career Nbr
      ADVIS_STATUS - Advisement Status
      COMPLETION_TERM - Completion Term
      DECLARE_DT - Declare Date
      DEGR_CHKOUT_STAT - Degree Checkout Status
      PLAN_SEQUENCE - Plan Sequence
      REQ_TERM - Requirement Term
      STDNT_DEGR - Student Degree Nbr

 ACAD_PLAN_TBL - Academic Plan Table
 Y    ACAD_PLAN - Academic Plan
 Y    EFFDT - Effective Date
 Y    INSTITUTION - Academic Institution
      ACAD_CAREER - Academic Career
      ACAD_PLAN_TYPE - Academic Plan Type
      ACAD_PROG - Academic Program
      CIP_CODE - CIP Code
      DEGREE - Degree
      DESCR - Description
      DESCRLONG - Description
      DESCRSHORT - Short Description
      DIPLOMA_DESCR - Diploma Description
      DIPLOMA_INDENT - Number of Characters to Indent
      DIPLOMA_PRINT_FL - Print on Diploma
      EFF_STATUS - Status as of Effective Date
      EVALUATE_PLAN - Evaluate Plan Before Program?
      FIRST_TERM_VALID - First Term Valid
      HEGIS_CODE - HEGIS Code
      PLN_REQTRM_DFLT - Requirement Term Default
      STUDY_FIELD - Field of Study
      TRANSCRIPT_LEVEL - Transcript Level
      TRNSCR_DESCR - Transcript Description
      TRNSCR_INDENT - Nbr of Chars Indnt on Transcr
      TRNSCR_PRINT_FL - Print on Transcript

 ACAD_PROG - Student Academic Program
 Y    ACAD_CAREER - Academic Career
 Y    EFFDT - Effective Date
 Y    EFFSEQ - Effective Sequence


07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
 Y    EMPLID - EmplID
 Y    STDNT_CAR_NBR - Student Career Nbr
      ACAD_LOAD_APPR - Approved Academic Load
      ACAD_PROG - Academic Program
      ACAD_PROG_DUAL - Dual Academic Program
      ACTION_DT - Action Date
      ADM_APPL_NBR - Application Nbr
      ADMIT_TERM - Admit Term
      APPL_PROG_NBR - Application Program Nbr
      CAMPUS - Campus
      COMPLETION_TERM - Completion Term
      DATA_FROM_ADM_APPL - Data from Admissions Appl
      DEGR_CHKOUT_STAT - Degree Checkout Status
      EXP_GRAD_TERM - Expected Graduation Term
      INSTITUTION - Academic Institution
      JOINT_PROG_APPR - Joint Program Approved
      PROG_ACTION - Program Action
      PROG_REASON - Action Reason
      PROG_STATUS - Academic Program Status
      REQ_TERM - Requirement Term

 ACAD_PROG_TBL - Academic Program Table
 Y    ACAD_PROG - Academic Program
 Y    EFFDT - Effective Date
 Y    INSTITUTION - Academic Institution
      ACAD_CALENDAR_ID - Academic Calendar
      ACAD_CAREER - Academic Career
      ACAD_GROUP - Academic Group
      ACAD_ORG - Academic Organization
      ACAD_PLAN - Academic Plan
      ACAD_PROG_DUAL - Dual Academic Program
      ACAD_STDNG_RULE - Academic Standing Rule
      ADVISOR_EDIT - Advisor Edit
      ASSOC_PROG_AS - Associate with Academic Prog
      ASSOC_PROG_HA - Associate with Academic Prog
      CALC_AS_BATCH_ONLY - Calculate in Batch Only
      CALC_HA_BATCH_ONLY - Calculate in Batch Only
      CAMPUS - Campus
      CANCEL_REASON - Cancel Drop Reason
      CAR_PTR_EXC_FG - Only if Outside Career
      CAR_PTR_EXC_RULE - Career Pointer Exception Rule
      CIP_CODE - CIP Code
      CMPLTD_NOTE_ID - Completed Transcript Note ID
      CRSE_COUNT_ENRL - Course Count Enrollment
      CRSE_COUNT_MIN - Min Course Count to Count
      DESCR - Description
      DESCRSHORT - Short Description
      DROP_PEN_GRADE - Drop with Penalty Grade
      DROP_PEN_GRADE_2 - Drop with Penalty Grade
      DROP_PEN_GRD_BAS - Drop with Penalty Grade Basis
      DROP_PEN_GRD_BAS_2 - Drop with Penalty Grade Basis2
      DROP_RET_RSN - Drop Reasn for Retained Record

07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      EFF_STATUS - Status as of Effective Date
      EXCL_TRM_CAT_AS_1 - Exclude Term Category 1
      EXCL_TRM_CAT_AS_2 - Exclude Term Category 2
      EXCL_TRM_CAT_AS_3 - Exclude Term Category 3
      EXCL_TRM_CAT_HA_1 - Exclude Term Category 1
      EXCL_TRM_CAT_HA_2 - Exclude Term Category 2
      EXCL_TRM_CAT_HA_3 - Exclude Term Category 3
      FA_ELIGIBILITY - Program Eligibility Flag
      FA_PRIMACY_NBR - Primacy Nbr
      FIRST_TERM_VALID - First Term Valid
      GRADE_TRANSFER - Default Grade- Transfer Credit
      GRADING_BASIS - Grading Basis
      GRADING_SCHEME - Grading Scheme
      HEGIS_CODE - HEGIS Code
      HONOR_AWARD_RULE - Honor Award Rule
      HONOR_DT_FG - Honor and Award Date Flag
      INCOMPLETE_GRADE - Incomplete Grade
      LAPSE_DAYS - Lapse Days
      LAPSE_GRADE - Lapse Grade
      LAPSE_NOTE_ID - Lapse Transcript Note ID
      LAPSE_TO_GRADE - Lapse To Grade
      LEVEL_LOAD_RULE - Academic Level Rule
      OBEY_FULLY_GRD_AS - Obey Fully Graded Date
      OBEY_FULLY_GRD_HA - Obey Fully Graded Date
      OEE_IND - Allow OEE Enrollment
      PRINT_CMPLTD_DATE - Print Completed Date
      PRINT_LAPSE_DATE - Print Lapse Date
      PROG_NORM_COMPLTN - IPEDS Normal Completion (yrs)
      REPEAT_CRSE_ERROR - Course Catalog Repeat Message
      REPEAT_ENRL_CTL - Process on Enrollment
      REPEAT_ENRL_SUSP - Temp Susp Rpt Ck on Enrl
      REPEAT_GRD_CK - Repeat Grade Check
      REPEAT_GRD_SUSP - Temp Susp Rpt Ck on Grading
      REPEAT_RULE - Repeat Rule
      RESIDENCY_REQ - Requires Residency Coding
      SPLIT_OWNER - Split Ownership
      TRANSCRIPT_LEVEL - Transcript Level
      WD_W_PEN_GRADE - Withdraw with Penalty Grade
      WD_W_PEN_GRD_BAS - Withdraw w/ Pen Grading Basis
      WD_W_PEN2_GRADE - Withdraw with Penalty 2 Grade
      WD_W_PEN2_GRD_BAS - Withdraw w/ Pen2 Grading Basis
      WD_WO_PEN_REASON - Withdraw Drop Rsn No Penalty

 ACAD_SUBPLAN - Student Academic Subplan Table
 Y    ACAD_CAREER - Academic Career
 Y    ACAD_PLAN - Academic Plan
 Y    ACAD_SUB_PLAN - Academic Sub-Plan
 Y    EFFDT - Effective Date
 Y    EFFSEQ - Effective Sequence
 Y    EMPLID - EmplID
 Y    STDNT_CAR_NBR - Student Career Nbr
      DECLARE_DT - Declare Date

07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      REQ_TERM - Requirement Term

 ACAD_SUBPLN_TBL - Academic Sub Plan Table
 Y    ACAD_PLAN - Academic Plan
 Y    ACAD_SUB_PLAN - Academic Sub-Plan
 Y    EFFDT - Effective Date
 Y    INSTITUTION - Academic Institution
      ACAD_SUBPLAN_TYPE - Academic Sub-Plan Type
      CIP_CODE - CIP Code
      DESCR - Description
      DESCRSHORT - Short Description
      DIPLOMA_DESCR - Diploma Description
      DIPLOMA_INDENT - Number of Characters to Indent
      DIPLOMA_PRINT_FL - Print on Diploma
      EFF_STATUS - Status as of Effective Date
      EVALUATE_SUBPLAN - Evaluate SubPlan Before Plan?
      FIRST_TERM_VALID - First Term Valid
      HEGIS_CODE - HEGIS Code
      SUBPLN_REQTRM_DFLT - Sub-Plan Req Term Default
      TRANSCRIPT_LEVEL - Transcript Level
      TRNSCR_DESCR - Transcript Description
      TRNSCR_INDENT - Nbr of Chars Indnt on Transcr
      TRNSCR_PRINT_FL - Print on Transcript

 CAMPUS_TBL - Campus Table
 Y    CAMPUS - Campus
 Y    EFFDT - Effective Date
 Y    INSTITUTION - Academic Institution
      DESCR - Description
      DESCRSHORT - Short Description
      EFF_STATUS - Status as of Effective Date
      FACILITY_CONFLICT - Check for Facility Conflict
      LOCATION - Location Code

 CLASS_ASSOC - Class Associations
 Y    ASSOCIATED_CLASS - Associated Class
 Y    CRSE_ID - Course ID
 Y    CRSE_OFFER_NBR - Course Offering Nbr
 Y    SESSION_CODE - Session
 Y    STRM - Term
      BILLING_FACTOR - Billing Factor
      COMPONENT_PRIMARY - Primary Component
      CRSE_CONTACT_HRS - Course Contact Hours
      CRSE_COUNT - Course Count
      GRADE_ROSTER_PRINT - Grade Roster Print
      GRADING_BASIS - Grading Basis
      INSTRUCTOR_EDIT - Instructor Edit
      RQMNT_DESIGNTN - Requirement Designation
      RQRMNT_GROUP - Requirement Group
      SEL_GROUP - Tuition Group
      SSR_COMPONENT - Course Component


07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      UNITS_ACAD_PROG - Academic Progress Units
      UNITS_FINAID_PROG - Financial Aid Progress Units
      UNITS_MAXIMUM - Maximum Units
      UNITS_MINIMUM - Minimum Units
      UPDATE_STDNT_ENRL - Update Student Enrl
      USE_BLIND_GRADING - Use Blind Grading
      USE_CATLG_RQS - Also Use Catalog Requisite

 CLASS_ATTRIBUTE - Class Attribute Table
 Y    CLASS_SECTION - Class Section
 Y    CRSE_ATTR - Course Attribute
 Y    CRSE_ATTR_VALUE - Course Attribute Value
 Y    CRSE_ID - Course ID
 Y    CRSE_OFFER_NBR - Course Offering Nbr
 Y    SESSION_CODE - Session
 Y    STRM - Term

 CLASS_TBL - Class Table
 Y    CLASS_SECTION - Class Section
 Y    CRSE_ID - Course ID
 Y    CRSE_OFFER_NBR - Course Offering Nbr
 Y    SESSION_CODE - Session
 Y    STRM - Term
      ACAD_CAREER - Academic Career
      ACAD_GROUP - Academic Group
      ACAD_ORG - Academic Organization
      AP_ACCOUNT - Account
      AP_AFF_INT1 - Fund Affiliate
      AP_AFF_INT2 - Operating Unit Affiliate
      AP_AFFILIATE - Affiliate
      AP_ALTACCT - Alternate Account
      AP_BUD_REF - Budget Reference
      AP_BUS_UNIT - Business Unit
      AP_CF1 - Chartfield 1
      AP_CF2 - Chartfield 2
      AP_CF3 - Chartfield 3
      AP_CLASS_FLD - Class
      AP_DEPTID - Department
      AP_FUND_CODE - Fund
      AP_LEDGER - Ledger
      AP_OP_UNIT - Operating Unit
      AP_PRODUCT - Product
      AP_PROG_CODE - Program
      AP_PROJ_ID - Project ID
      ASSOCIATED_CLASS - Associated Class
      ATTEND_GENERATE - Generate Class Mtg Attendance
      ATTEND_SYNC_REQD - Sync Attendance with Class Mtg
      AUTO_ENRL_WAITLIST - Auto Enroll from Wait List
      AUTO_ENROLL_SECT_1 - 1st Auto Enroll Section
      AUTO_ENROLL_SECT_2 - 2nd Auto Enroll Section
      CAMPUS - Campus


07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      CAMPUS_EVENT_NBR - Event ID
      CANCEL_DT - Cancel Date
      CATALOG_NBR - Catalog Nbr
      CLASS_NBR - Class Nbr
      CLASS_STAT - Class Status
      CLASS_TYPE - Class Type
      CNCL_IF_STUD_ENRLD - Cancel if Student Enrolled
      COMBINED_SECTION - Combined Section
      CONSENT - Type of Consent Required
      CRS_TOPIC_ID - Course Topic ID
      DESCR - Description
      DYN_DT_CALC_REQ - Dynamic Date Calc Required
      DYN_DT_INCLUDE - Include in Dynamic Date Calc
      EMPLID - EmplID
      END_DT - End Date
      ENRL_CAP - Enrollment Capacity
      ENRL_STAT - Enrollment Status
      ENRL_TOT - Enrollment Total
      EQUIV_CRSE_ID - Equivalent Course Group
      EXAM_SEAT_SPACING - Exam Seat Spacing
      EXT_WRITEOFF - External Writeoff
      FEES_EXIST - Fees Exist Flag
      GL_INTERFACE_REQ - GL Interface Required
      HOLIDAY_SCHEDULE - Holiday Schedule
      INSTITUTION - Academic Institution
      INSTRUCTION_MODE - Instruction Mode
      LMS_CLASS_EXT_DTTM - Last LMS Class Extract Datetm
      LMS_ENRL_EXT_DTTM - Last LMS Enroll Extract Datetm
      LMS_FILE_TYPE - LMS Extract File Type
      LMS_GROUP_ID - LMS Extract Group ID
      LMS_PROVIDER - Provider for Authentication
      LMS_URL - LMS URL
      LOCATION - Location Code
      MIN_ENRL - Minimum Enrollment Number
      NEXT_STDNT_POSITIN - Next Student Position
      OVRD_CRSE_EQUIV_ID - Override Equivalent Course
      PRIM_INSTR_SECT - Primary Instructional Section
      PRINT_TOPIC - Print Topic in Schedule
      RCV_FROM_ITEM_TYPE - Receivables From Item Type
      RESECTION - Resection to Section
      ROOM_CAP_REQUEST - Requested Room Capacity
      SCHEDULE_PRINT - Schedule Print
      SSR_COMPONENT - Course Component
      START_DT - Start Date
      STDNT_SPEC_PERM - Student Specific Permissions
      SUBJECT - Subject Area
      WAIT_CAP - Wait List Capacity
      WAIT_TOT - Wait List Total
      WAITLIST_DAEMON - WAITLIST DAEMON SWITCH
      WRITEOFF_ACCOUNT - Account
      WRITEOFF_AFF_INT1 - Fund Affiliate
      WRITEOFF_AFF_INT2 - Operating Unit Affiliate

07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      WRITEOFF_AFFILIATE - Affiliate
      WRITEOFF_ALTACCT - Alternate Account
      WRITEOFF_BUD_REF - Budget Reference
      WRITEOFF_BUS_UNIT - Business Unit
      WRITEOFF_CF1 - Chartfield 1
      WRITEOFF_CF2 - Chartfield 2
      WRITEOFF_CF3 - Chartfield 3
      WRITEOFF_CLASS_FLD - Class Field
      WRITEOFF_DEPTID - Department
      WRITEOFF_FUND_CODE - Fund Code
      WRITEOFF_LEDGER - Ledger
      WRITEOFF_OP_UNIT - Operating Unit
      WRITEOFF_PRODUCT - Product
      WRITEOFF_PROG_CODE - Program Code
      WRITEOFF_PROJ_ID - Project ID

 COUNTRY_TBL - Countries
 Y    COUNTRY - Country
      ADDR_VALIDAT - Enable Address Validation
      COUNTRY_2CHAR - 2-Char Country Code
      DESCR - Description
      DESCRSHORT - Short Description
      EO_SEC_PAGE_NAME - Address Edit Page
      EU_MEMBER_STATE - EU Member State
      POST_SRCH_AVAIL - Post Search Available

 CRSE_ATTR_TBL - Course Print Attribute Table
 Y    CRSE_ATTR - Course Attribute
 Y    EFFDT - Effective Date
      DESCR - Description
      DESCRSHORT - Short Description
      EFF_STATUS - Status as of Effective Date

 CRSE_ATTR_VALUE - Course Attribute Value Tbl
 Y    CRSE_ATTR - Course Attribute
 Y    CRSE_ATTR_VALUE - Course Attribute Value
 Y    EFFDT - Effective Date
      CATALOG_PRINT - Catalog Print
      DESCR - Description
      DESCRFORMAL - Formal Description
      SCHEDULE_PRINT - Schedule Print

 CRSE_ATTRIBUTES - Course Attribute Tbl
 Y    CRSE_ATTR - Course Attribute
 Y    CRSE_ATTR_VALUE - Course Attribute Value
 Y    CRSE_ID - Course ID
 Y    EFFDT - Effective Date

 CRSE_CATALOG - Course Catalog Data
 Y    CRSE_ID - Course ID
 Y    EFFDT - Effective Date

07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      ALLOW_MULT_ENROLL - Allow Multiple Enroll in Term
      COMPONENT_PRIMARY - Primary Component
      CONSENT - Type of Consent Required
      COURSE_TITLE_LONG - Long Course Title
      CRSE_CONTACT_HRS - Course Contact Hours
      CRSE_COUNT - Course Count
      CRSE_REPEAT_LIMIT - Total Completions Allowed
      CRSE_REPEATABLE - Repeat for Credit
      DESCR - Description
      DESCRLONG - Description
      EFF_STATUS - Status as of Effective Date
      ENRL_UN_LD_CLC_TYP - Enrollment Unit Load Calc Type
      EQUIV_CRSE_ID - Equivalent Course Group
      FEES_EXIST - Fees Exist Flag
      GRADE_ROSTER_PRINT - Grade Roster Print
      GRADING_BASIS - Grading Basis
      INSTRUCTOR_EDIT - Instructor Edit
      LST_MULT_TRM_CRS - Last Course of Mult Term Seq
      RQMNT_DESIGNTN - Requirement Designation
      SSR_COMPONENT - Course Component
      UNITS_ACAD_PROG - Academic Progress Units
      UNITS_FINAID_PROG - Financial Aid Progress Units
      UNITS_MAXIMUM - Maximum Units
      UNITS_MINIMUM - Minimum Units
      UNITS_REPEAT_LIMIT - Total Units Allowed

 CRSE_OFFER - Course Catalog Offerings
 Y    CRSE_ID - Course ID
 Y    CRSE_OFFER_NBR - Course Offering Nbr
 Y    EFFDT - Effective Date
      ACAD_CAREER - Academic Career
      ACAD_GROUP - Academic Group
      ACAD_ORG - Academic Organization
      AP_ACCOUNT - Account
      AP_AFF_INT1 - Fund Affiliate
      AP_AFF_INT2 - Operating Unit Affiliate
      AP_AFFILIATE - Affiliate
      AP_ALTACCT - Alternate Account
      AP_BUD_REF - Budget Reference
      AP_BUS_UNIT - Business Unit
      AP_CF1 - Chartfield 1
      AP_CF2 - Chartfield 2
      AP_CF3 - Chartfield 3
      AP_CLASS_FLD - Class
      AP_DEPTID - Department
      AP_FUND_CODE - Fund
      AP_LEDGER - Ledger
      AP_OP_UNIT - Operating Unit
      AP_PRODUCT - Product
      AP_PROG_CODE - Program
      AP_PROJ_ID - Project ID
      CAMPUS - Campus

07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      CATALOG_NBR - Catalog Nbr
      CATALOG_PRINT - Catalog Print
      CIP_CODE - CIP Code
      COURSE_APPROVED - Course Approved
      DYN_CLASS_DATA - Dynamic Class Data Rule
      EXT_WRITEOFF - External Writeoff
      GL_INTERFACE_REQ - GL Interface Required
      HEGIS_CODE - HEGIS Code
      INSTITUTION - Academic Institution
      OEE_DYN_DATE_RULE - OEE Dynamic Date Rule
      OEE_IND - Allow OEE Enrollment
      RCV_FROM_ITEM_TYPE - Receivables From Item Type
      RQRMNT_GROUP - Requirement Group
      SCHED_PRINT_INSTR - Print Instructor in Schedule
      SCHED_TERM_ROLL - Schedule Term Roll
      SCHEDULE_COURSE - Allow Course to be Scheduled
      SCHEDULE_PRINT - Schedule Print
      SEL_GROUP - Tuition Group
      SPLIT_OWNER - Split Ownership
      SUBJECT - Subject Area
      USE_BLIND_GRADING - Use Blind Grading
      WRITEOFF_ACCOUNT - Account
      WRITEOFF_AFF_INT1 - Fund Affiliate
      WRITEOFF_AFF_INT2 - Operating Unit Affiliate
      WRITEOFF_AFFILIATE - Affiliate
      WRITEOFF_ALTACCT - Alternate Account
      WRITEOFF_BUD_REF - Budget Reference
      WRITEOFF_BUS_UNIT - Business Unit
      WRITEOFF_CF1 - Chartfield 1
      WRITEOFF_CF2 - Chartfield 2
      WRITEOFF_CF3 - Chartfield 3
      WRITEOFF_CLASS_FLD - Class Field
      WRITEOFF_DEPTID - Department
      WRITEOFF_FUND_CODE - Fund Code
      WRITEOFF_LEDGER - Ledger
      WRITEOFF_OP_UNIT - Operating Unit
      WRITEOFF_PRODUCT - Product
      WRITEOFF_PROG_CODE - Program Code
      WRITEOFF_PROJ_ID - Project ID

 EMAIL_ADDRESSES - Email Addresses
 Y    E_ADDR_TYPE - Email Type
 Y    EMPLID - EmplID
      EMAIL_ADDR - Email Address
      PREF_EMAIL_FLAG - Preferred

 INSTITUTION_TBL - Institution Table
 Y    EFFDT - Effective Date
 Y    INSTITUTION - Academic Institution
      ADDR_FIELD1 - Address Field 1
      ADDR_FIELD2 - Address Field 2


07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      ADDR_FIELD3 - Address Field 3
      ADDR_USAGE - Address Usage
      ADDRESS1 - Address Line 1
      ADDRESS2 - Address Line 2
      ADDRESS3 - Address Line 3
      ADDRESS4 - Address Line 4
      ASSIGN_TYPE - Assignment Type
      AUTO_ENRL_WAITLIST - Auto Enroll from Wait List
      CAMPUS - Campus
      CITY - City
      CLASS_MTG_ATND_TYP - Class Meeting Attendance Type
      COUNTRY - Country
      COUNTY - County
      CRSE_CNTCT_HRS_PCT - Course Component Workload Hrs%
      DESCR - Description
      DESCRFORMAL - Formal Description
      DESCRSHORT - Short Description
      E_ADDR_TYPE - Email Type
      EFF_STATUS - Status as of Effective Date
      ENRL_ACTION_REASON - Enrollment Action Reason
      EXT_USERID_OPT - UserID Extract Option
      FA_WDCAN_RSN - FA Withdraw Cancel Reason
      FACILITY_CONFLICT - Check for Facility Conflict
      FICE_CD - FICE Code
      FULLTIM_LIMIT_WARN - Full-Time Warning Limit %
      FULLTIME_LIMIT_PCT - Full-Time Assigned FTE %
      GEO_CODE - Tax Vendor Geographical Code
      GRAD_NAME_CHG - Allow Graduation Name Change
      GRADING_BASIS - Grading Basis
      GRADING_BASIS_SCH - School Grading Basis
      GRADING_SCHEME - Grading Scheme
      HOUSE_TYPE - House Type
      IN_CITY_LIMIT - In City Limit
      INSTRUCTOR_CLASS - Instructor Assignment Class
      LMS_FILE_TYPE - LMS Extract File Type
      LMS_PROVIDER - Provider for Authentication
      LOAD_CALC_APPLY - Calculate Workload
      NSLC_AGD_RULE - AGD Rule
      NSLC_MONTH_FACTOR - NSC Month Factor
      NUM1 - Number 1
      NUM2 - Number 2
      PARTTIM_LIMIT_WARN - Part-Time Warning Limit %
      PARTTIME_LIMIT_PCT - Part-Time Assigned FTE %
      PHONE_TYPE - Phone Type
      POSTAL - Postal Code
      PRINT_NID - Print National ID on Enrl. Ver
      REPEAT_CHK_TOPIC - Repeat Check at Topic Level
      REPEAT_ENRL_CTL - Process on Enrollment
      REPEAT_ENRL_SUSP - Temp Susp Rpt Ck on Enrl
      REPEAT_GRD_CK - Repeat Grade Check
      REPEAT_GRD_SUSP - Temp Susp Rpt Ck on Grading
      RESIDENCY_REQ - Requires Residency Coding

07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      SAD_SL_PARTICIPANT - Studielink Participant
      SCC_AUS_DEST - DEST, HECS, Centrelink, TAC
      SCC_CAN_GOV_RPT - Canada
      SCC_HE_USED_NLD - Higher Education
      SCC_NZL_ENR - New Zealand
      SCC_NZL_NZQA - NZQA
      SSR_CLASS_CANC_ENR - Drop Related Components
      SSR_CLASS_CANC_NON - Drop Related Components
      SSR_ENBL_ACAD_PROG - Select Acad Prog During Enroll
      SSR_RPT_DATE_ENRL - On Enrollment Process
      SSR_RPT_DATE_PROC - On Repeat Process
      SSR_USE_WEEKS - Use Term/Session Weeks in Calc
      STATE - State
      STDNT_ATTR_COHORT - Student Attribute for Cohort
      STDNT_SPEC_PERM - Student Specific Permissions
      UNITS_ACAD_PRG_PCT - Academic Progress Units %

 PSXLATITEM - Translate Value Items
 Y    EFFDT - Effective Date
 Y    FIELDNAME - Field Name
 Y    FIELDVALUE - Field Value
      EFF_STATUS - Status as of Effective Date
      LASTUPDDTTM - Last Update Date/Time
      LASTUPDOPRID - Last Update User ID
      SYNCID - Synchronization ID
      XLATLONGNAME - Translate Long Name
      XLATSHORTNAME - Translate Short Name

 RESIDENCY_OFF - Official Residency Data
 Y    ACAD_CAREER - Academic Career
 Y    EFFECTIVE_TERM - Effective Term
 Y    EMPLID - EmplID
 Y    INSTITUTION - Academic Institution
      ADMISSION_EXCPT - Admission Residency Exception
      ADMISSION_RES - Admissions Residency
      CITY - City
      COMMENTS - Comment
      COUNTRY - Country
      COUNTY - County
      FIN_AID_FED_EXCPT - Fin Aid Fed Residency Excpt
      FIN_AID_FED_RES - Fin Aid Federal Residency
      FIN_AID_ST_EXCPT - Fin Aid St Residency Excpt
      FIN_AID_ST_RES - Fin Aid State Residency
      POSTAL - Postal Code
      RESIDENCY - Residency
      RESIDENCY_DT - Residency Date
      SCC_DISTRICT - District
      STATE - State
      TUITION_EXCPT - Tuition Residency Exception
      TUITION_RES - Tuition Residency



07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
 SCTN_CMBND - Sections Combined
 Y    CLASS_NBR - Class Nbr
 Y    INSTITUTION - Academic Institution
 Y    SCTN_COMBINED_ID - Combined Sections ID
 Y    SESSION_CODE - Session
 Y    STRM - Term

 SCTN_CMBND_TBL - Sections Combined Table
 Y    INSTITUTION - Academic Institution
 Y    SCTN_COMBINED_ID - Combined Sections ID
 Y    SESSION_CODE - Session
 Y    STRM - Term
      COMBINATION_TYPE - Combination Type
      DESCR - Description
      DESCRSHORT - Short Description
      ENRL_CAP - Enrollment Capacity
      ENRL_TOT - Enrollment Total
      PERM_COMBINATION - Permanent Combination
      ROOM_CAP_REQUEST - Requested Room Capacity
      SKIP_MTGPAT_EDIT - Skip Mtg Pattern & Instr Edit
      WAIT_CAP - Wait List Capacity
      WAIT_TOT - Wait List Total

 SESS_TIME_PEROD - Session Time Periods
 Y    ACAD_CAREER - Academic Career
 Y    INSTITUTION - Academic Institution
 Y    SESSION_CODE - Session
 Y    STRM - Term
 Y    TIME_PERIOD - Time Period
      END_DT - End Date

 SESSION_TBL - Session Definition Table
 Y    ACAD_CAREER - Academic Career
 Y    INSTITUTION - Academic Institution
 Y    SESSION_CODE - Session
 Y    STRM - Term
      CENSUS_DT - Census Date
      ENROLL_OPEN_DT - Open Enrollment Date
      FACILITY_ASSIGNMNT - Facility Assignment Run Date
      FIRST_ENRL_DT - First Date to Enroll
      HOLIDAY_SCHEDULE - Holiday Schedule
      LAST_ENRL_DT - Last Date to Enroll
      LAST_WAIT_DT - Last Date for Wait List
      SESS_BEGIN_DT - Session Beginning Date
      SESS_END_DT - Session End Date
      SESSN_APPT_CNTL - Appointment Control Session
      SESSN_ENRL_CNTL - Enrollment Control Session
      SIXTY_PCT_DT - Sixty Percent Point in Time
      SSR_ENR_APT_APPROV - Enrollment Appointments
      SSR_VAL_APT_APPROV - Validation Appointments
      USE_DYN_CLASS_DATE - Use Dynamic Class Dates

07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      WEEKS_OF_INSTRUCT - Weeks of Instruction

 STATE_TBL - State Codes/Names w/in Country
 Y    COUNTRY - Country
 Y    STATE - State
      DESCR - Description
      DESCR_AC - Alternate Char Description
      NUMERIC_CD - Numeric Code

 STDNT_CONS_STAT - Student Consolidated Stats
 Y    ACAD_STATS_PERIOD - Academic Statistics Period
 Y    EMPLID - EmplID
 Y    INSTITUTION - Academic Institution
      ACAD_CAREER - Academic Career
      ACAD_LEVEL_BOT - Academic Level - Term Start
      ACAD_LEVEL_BOT_CL - Acad Level BOT Calculated
      ACAD_LEVEL_EOT - Academic Level - Term End
      ACAD_LEVEL_EOT_CL - Acad Level EOT Calculated
      ACAD_LEVEL_IPED_CL - IPEDS Academic Level
      ACAD_LEVEL_IPEDS - IPEDS Academic Level
      ACAD_LEVEL_PROJ - Academic Level - Projected
      ACAD_LEVEL_PROJ_CL - Acad Level Proj Calculated
      ACAD_LOAD_APPR - Approved Academic Load
      ACAD_LOAD_NSLC_CL - NSC Academic Load
      ACAD_PLAN - Academic Plan
      ACAD_PROG_MAIN - Academic Program
      ACAD_PROG_PRIMARY - Primary Academic Program
      ACAD_SUB_PLAN - Academic Sub-Plan
      ACAD_YEAR - Academic Year
      ACADEMIC_LOAD - Academic Load
      ACADEMIC_LOAD_CL - Academic Load Calculated
      ACADEMIC_LOAD_NSLC - NSC Academic Load
      AGE_CATEGORY_SR - Age Category
      ATHLETIC_AID - Athletic Aid
      BILLING_CAREER - Billing Career
      CAMPUS - Campus
      CLASS_RANK_NBR - Class Rank Nbr
      CLASS_RANK_TOT - Class Rank Total
      COMPLETION_TERM - Completion Term
      CONS_STATUS - Consolidation Status
      CORRECTION_STATUS - Correction Status
      COUNTRY - Country
      CUM_GPA - Cumulative GPA
      CUM_GPA_CL - Cumulative GPA Calculated
      CUM_RESIDENT_TERMS - Cumulative In Residence Terms
      CUR_GPA - Current GPA
      CUR_RESIDENT_TERMS - Current In Residence Terms
      DEGR_CONFER_DT - Confer Date
      DEGREE - Degree
      ELIG_TO_ENROLL - Eligible to Enroll
      END_DATE - End Date


07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      ENRL_STAT_CHG_DT - Enrollment Status Change Date
      ETHNIC_GROUP_SR - Ethnic Group
      EXP_GRAD_TERM - Expected Graduation Term
      EXT_ORG_ID - External Org ID
      EXTRA_ACTIVITY - Extracurricular Activity
      FA_LOAD - Financial Aid Load
      FA_UNIT_WARNING - Excluded FA Eligible Term Warn
      FORM_OF_STUDY - Form of Study
      FORM_OF_STUDY_CL - Form of Study Calculated
      FORM_OF_STUDY_PD - Form of Study for Period
      FULLY_ENRL_DT - Fully Enrolled Date
      FULLY_GRADED_DT - Fully Graded Date
      GPA_CL - GPA Calculated
      GRADE_POINTS - Grade Points
      GRADE_POINTS_FA - Financial Aid Grade Points
      LAST_DATE_ATTENDED - Last Date of Attendance
      LASTNAME_RPTD_NSLC - Last Name Reported NSC
      LEVEL_LOAD_RULE - Academic Level Rule
      MULTI_ACAD_CAREER - Multiple Academic Career
      NSLDS_LOAN_YEAR - NSLDS Loan Year
      OPRID - User ID
      OVRD_ACAD_LVL_ALL - Override All Academic Levels
      OVRD_ACAD_LVL_PROJ - Override Projected Level
      OVRD_ACADEMIC_LOAD - Override Academic Load
      OVRD_CUM_GPA - Override Cum GPA
      OVRD_FORM_OF_STUDY - Override Form of Study
      OVRD_GPA - Override GPA
      OVRD_TOT_CUM - Override Total Cumulative Unit
      OVRD_TUIT_GROUP - Override Tuition Group
      OVRD_UNT_TAKEN_PRG - Override Units for Progress
      OVRD_WDRW_SCHED - Override Withdrawal Schedule
      PREV_STATSPER_NSLC - Prev Acad Stats Period NSC
      PRO_RATA_ELIGIBLE - Pro-Rata Eligible
      PROG_STATUS - Academic Program Status
      REFUND_PCT - Refund Percentage
      REFUND_SCHEME - Refund Scheme
      RESET_CUM_STATS - Reset Cum Stats at Term Start
      SEL_GROUP - Tuition Group
      SF_1098_GRAD_FLG - 1098 Grad Flag
      SF_1098_HLFTME_FLG - 1098 Half Time Flag
      SF_CORRECTION_DTTM - Correction Date Time
      SF_ORIGINAL_PRT_DT - Original Print Date
      SF_ORIGINAL_SENTDT - Original Sent DAte
      SF_OVERRIDE_GRAD - Override Grad Flag
      SF_OVERRIDE_HALF - Override Half Flag
      SSN_RPTD_NSLC - SSN Reported NSC
      START_DATE - Start Date for Gen Standing PO
      STDNT_CAR_NBR - Student Career Nbr
      STDNT_CAR_NBR_MAIN - Student Career Nbr
      STDNT_COHORT_PRIM - Primary Student Cohort
      STRM - Term
      STUDY_AGREEMENT - Study Agreement

07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      TC_UNITS_ADJUST - TC Units Adjustment
      TERM_TYPE - Term Unit Type
      TOT_AUDIT - Total Audited
      TOT_CUMULATIVE - Total Cumulative Units
      TOT_CUMULATIVE_CL - Total Cumulative Units
      TOT_GRADE_POINTS - Total Grade Points
      TOT_GRD_POINTS_FA - Total Fin Aid Grade Points
      TOT_INPROG_GPA - Total In Progress - GPA
      TOT_INPROG_NOGPA - Total In Progress -Not for GPA
      TOT_OTHER - Total from Other Credit
      TOT_PASSD_FA - Total Fin Aid Units Passed
      TOT_PASSD_GPA - Total Passed Toward GPA
      TOT_PASSD_NOGPA - Total Passed Not Toward GPA
      TOT_PASSD_PRGRSS - Total Passed for Progress
      TOT_TAKEN_FA - Total Fin Aid Units Taken
      TOT_TAKEN_FA_GPA - Total Fin Aid Taken Toward GPA
      TOT_TAKEN_GPA - Total Taken Toward GPA
      TOT_TAKEN_NOGPA - Total Taken Not Toward GPA
      TOT_TAKEN_PRGRSS - Total Taken for Progress
      TOT_TEST_CREDIT - Total From Test Credit
      TOT_TRNSFR - Total Transferred
      TRF_GRADE_POINTS - Transfer Grade Points
      TRF_PASSED_GPA - Transfer Passed for GPA
      TRF_PASSED_NOGPA - Transfer Passed Not for GPA
      TRF_RESIDENT_TERMS - Transfer In Residence Terms
      TRF_TAKEN_GPA - Transfer Taken for GPA
      TRF_TAKEN_NOGPA - Transfer Taken Not for GPA
      TUITION_RES_TERMS - Tuition Residency
      UNIT_MULTIPLIER - Unit Multiplier
      UNT_AUDIT - Units Audited
      UNT_INPROG_GPA - Units In Progress - GPA
      UNT_INPROG_NOGPA - Unit In Progress - Not for GPA
      UNT_OTHER - Units from Other Credit
      UNT_PASSD_FA - Fin Aid Progress Units Passed
      UNT_PASSD_GPA - Units Passed Toward GPA
      UNT_PASSD_NOGPA - Units Passed Not Toward GPA
      UNT_PASSD_PRGRSS - Units Passed for Progress
      UNT_TAKEN_FA - Fin Aid Progress Units Taken
      UNT_TAKEN_FA_GPA - FA Units Taken Toward GPA
      UNT_TAKEN_GPA - Units Taken Toward GPA
      UNT_TAKEN_NOGPA - Units Taken Not Toward GPA
      UNT_TAKEN_PRGRS_CL - Calculated Progress Units
      UNT_TAKEN_PRGRSS - Units Taken for Progress
      UNT_TERM_TOT - Total Term Units
      UNT_TEST_CREDIT - Units from Test Credit
      UNT_TRNSFR - Units Transferred
      WITHDRAW_CODE - Withdrawal \ Cancel
      WITHDRAW_DATE - Withdrawal \ Cancel Date
      WITHDRAW_REASON - Withdrawal \ Cancel Reason

 TERM_TBL - Term Definition Table
 Y    ACAD_CAREER - Academic Career

07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
 Y    INSTITUTION - Academic Institution
 Y    STRM - Term
      ACAD_YEAR - Academic Year
      DESCR - Description
      DESCRSHORT - Short Description
      HOLIDAY_SCHEDULE - Holiday Schedule
      INCLUDE_IN_SS - Show in Self-Service
      SESSION_CODE - Session
      SIXTY_PCT_DT - Sixty Percent Point in Time
      SSR_PLNDISPONLY_DT - Wish List Display Only Date
      SSR_SSENRLAVAIL_DT - Hide Self-Service Enrl Term
      SSR_TRMAC_LAST_DT - Max Program Effdt for Term
      TERM_BEGIN_DT - Term Begin Date
      TERM_CATEGORY - Term Category
      TERM_END_DT - Term Ending Date
      TRANSCIPT_DT_PRT - Transcript Date Print
      USE_DYN_CLASS_DATE - Use Dynamic Class Dates
      WEEKS_OF_INSTRUCT - Weeks of Instruction

 TIME_PERIOD_TBL - Time Period Table
 Y    ACAD_CAREER - Academic Career
 Y    SETID - SetID
 Y    TIME_PERIOD - Time Period
      DESCR - Description
      DESCRSHORT - Short Description
      SSR_PLNDISPONLY_DT - Wish List Display Only Date
      SSR_SSENRLAVAIL_DT - Hide Self-Service Enrl Term

 TIME_PERIOD_TBL - Time Period Table
 Y    SETID - SetID
 Y    ACAD_CAREER - Academic Career
 Y    TIME_PERIOD - Time Period
      DESCR - Description
      DESCRSHORT - Short Description




07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
                      STUDENT FINANCIALS VIEWS AND TABLES

Listing of Views and Tables

   Account Information
     Account SF - Account Balance by Emplid by Account Type
     Account Tot Vw - Total Account Balance by Emplid
     Item SF - Account Transactions by Emplid by Item Number


   GL Feed
     SF Acctg Ln - SF Accounting Line Table


   Setup Information
     Acct Typ Tbl SF - Account Type Table
     Item Type Tbl - Item Type Table
     Item Type Vw - Item Type View




    07/07/2008
    D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
Fields Included in Each View and Table
     Account SF - Account Balance by Emplid by Account Type
     Y    ACCOUNT_NBR - Account Nbr
     Y    ACCOUNT_TERM - Account Term
     Y    BUSINESS_UNIT - Business Unit
     Y    EMPLID - EmplID
          ACAD_YEAR - Academic Year
          ACCOUNT_BALANCE - Account Balance
          ACCOUNT_TYPE_SF - Account Type
          ACCT_STATUS - Account Status
          BILL_REQ_ID - Bill Request ID
          CLOSE_DT - Date Closed
          CONTRACT_NUM - Contract Number
          INCLUDE_BILLING - Include Billing
          INCLUDE_IN_BALANCE - Include in Balance
          INCLUDE_PREPAY - Include Pre-Pay
          INCLUDE_TRANSFER - Include Transfers
          LAST_ACCT_DT_AGED - Last Accounting Date Aged
          LAST_AGING_DT - Last Aging Date
          OPEN_DT - Created
          OVERR_BILL_REQ_ID - Override Bill Request ID

     Account Tot Vw - Total Account Balance by Emplid
     Y    BUSINESS_UNIT - Business Unit
     Y    EMPLID - EmplID
          ACCOUNT_BALANCE - Account Balance

     Acct Typ Tbl SF - Account Type Table
     Y    SETID - SetID
     Y    ACCOUNT_TYPE_SF - Account Type
          ACCT_NUM_PREFIX - Account Nbr Prefix
          ACCT_PER_TERM - Account Per Term
          BALANCE_FWD_SW - Balance Forward
          CANCEL_CLASS - Include in Class Cancellation
          DESCR - Description
          DESCRSHORT - Short Description
          EXCLUDE_AGE_FLG - Exclude From Aging Total
          INCLUDE_BILLING - Include Billing
          INCLUDE_IN_BALANCE - Include in Balance
          INCLUDE_PREPAY - Include Pre-Pay
          INCLUDE_TRANSFER - Include Transfers
          LATE_FEE_ACCT_IND - Late Fee Account
          LATE_FEE_ACCT_ORG - Ext Org Late Fee Account
          LATE_FEE_CODE - Late Fee Code
          LATE_FEE_CODE_ORG - Ext Org Late Fee Code
          MOVE_EXCESS_FA - Move Excess Financial Aid
          MOVE_EXCESS_PMT - Move Excess Payment
          MOVE_EXCESS_WAIVER - Move Excess Waiver
          PMT_PLAN_ACCT_FLG - Payment Plan Account
          PRIMARY_ACCOUNT - Primary Account

    07/07/2008
    D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      SF_ACCOUNT_CLASS - Account Class
      UNAPP_PMT_CREDHIST - View Unappld Pymt Credit Hist

 Item SF - Account Transactions by Emplid by Item Number
 Y    BUSINESS_UNIT - Business Unit
 Y    COMMON_ID - ID
 Y    ITEM_NBR - Item Nbr
 Y    SA_ID_TYPE - ID Type
      ACAD_CAREER - Academic Career
      ACAD_YEAR - Academic Year
      ACCOUNT_NBR - Account Nbr
      ACCOUNT_TERM - Account Term
      ACCOUNT_TYPE_SF - Account Type
          ADM       Admission Fees
          CNV       Converson Balance from ISIS
          END       Enrollment Deposits Paid       UMS01
          ENR       Enrollment Fees
          MCF       Misc Charges and Fines
          OTH       Other
          PP        Payment Plans                  UMS01
          PPL       Payment Plans
          PRL       Payroll Deduction Payment Plan UMS03,UMS04,UMS07
          RMB       Room and Board
          SCH       Scholarships                   UMS01
          SPN       Sponsored Charges
          TUT       Tuition
          UND       Undefined Postings
          XCP       Cross Campus Account
          XFA       Excess Financial Aid
          XPY       Excess Payments
          XWA       Excess Waivers                 UMS06
          XWV       Excess Waiver Account          UMS01,UMS02,UMS03,UMS04,UMS05,UMS07
      ACTUAL_BILLING_DT - Actual Billing Date
      ADM_APPL_NBR - Application Nbr
      AID_YEAR - Aid Year
      APPLIED_AMT - Applied Amount
      BILLING_CAREER - Billing Career
      BILLING_DT - Billing Date
      CALENDAR_YEAR - Calendar Year
      CHARGE_PRIORITY - Charge Priority List
      CLASS_CRSE_FEE_IND - Class/Course Fee Indicator
      CLASS_NBR - Class Nbr
      COLLECTION_ID - Collection ID
      CONTRACT_AMT - Contract Amt
      CONTRACT_EMPLID - Contract ID
      CONTRACT_NUM - Contract Number
      COURSE_LIST - Course List
      CRSE_ID - Course ID
      CUR_RT_TYPE - Exchange Rate Type
      CURRENCY_CD - Currency Code
      DEPOSIT_NBR - Deposit Nbr


07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      DISBURSEMENT_DATE - Disbursement Date
      DUE_DT - Due Date
      EMPLID - EmplID
      ENCUMBERED_AMT - Amount Encumbered
      EXT_ORG_ID - External Org ID
      FEDERAL_TAX_RT - Federal Tax Rate
      FEE_CD - Fee Code
      GL_ASSESSED_AMT - GL Assessed
      GL_BALANCED_AMT - GL Assessed
      GL_FROM_SUBFEE - GL from Sub Fees
      GL_SATISFIED_AMT - GL Satisfied Amount
      INTEREST_DT - Interest Date
      ITEM_AMT - Item Amount
      ITEM_BALANCE - Item Balance
      ITEM_EFFECTIVE_DT - Item Effective Date
      ITEM_NBR_SOURCE - Item Nbr - Src Charge Nbr
      ITEM_STATUS - Item Status
      ITEM_TERM - Item Term
      ITEM_TYPE - Item Type
      ITEM_TYPE_CD - Item Type Code
          A          Application Fee                 App Fee
          B          Billing Only                    Billing
          C          Charge                          Charge
          D          Deposit                         Deposit
          F          Financial Aid                   Fin. Aid
          G          GL Interface Only               GL Only
          H          Withholding                     Withhold
          I          Interest                        Interest
          L          Pre-Paid Tuition                Pre-paid
          P          Payment                         Payment
          R          Refund                          Refund
          T          Transfers                       Transfers
          V          Contributor Relations           CR
          W          Waiver                          Waiver
          X          Write-off                       Write-off
          Z          Pay Plan Credit                 Credit
      LAST_ACTIVITY_DATE - Last Activity Date
      LATE_FEE_CODE - Late Fee Code
      LOCAL_TAX_RT - Local Tax Rate
      NRA_TAXATION_SWTCH - NRA Taxation Option
      ORIG_EFF_DT - Original Effective Date
      ORIGINAL_ACCT_TERM - Original Account Term
      ORIGNL_CURRENCY_CD - Currency Code
      ORIGNL_ITEM_AMT - Item Amount
      PAYMENT_ID_NBR - Payment ID Nbr
      PRIORITY - Priority
      PRIORITY_PMT_FLG - Payment Priority Flag
      RATE_DIV - Rate Divisor
      RATE_MULT - Rate Multiplier
      RECEIPT_NBR - Receipt Number
      REF1_DESCR - Reference Nbr
      REFUND_EMPLID - Refund ID

07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      REFUND_EXT_ORG_ID - Refund External Org ID
      REFUND_NBR - Refund Nbr
      REFUND_ORG_CONTACT - Refund Org Contact
      SEL_GROUP - Tuition Group
      SESSION_CODE - Session
      SF_ADM_APPL_DEL - Application Deleted
      SF_DEPOSIT_ID - Deposit ID
      SF_PMT_REF_NBR - Reference Nbr
      SRVC_IND_DTTM - Service Indicator Date Time
      STATE_TAX_RT - State Tax Rate
      STDNT_CAR_NBR - Student Career Nbr
      T4_SENT_AMT - T4 Sent Amt
      TAX_ADJ_WHOLDINGS - Gross Taxable Payments YTD
      TAX_AUTHORITY_CD - Tax Authority
      TAX_CD - Tax Code
      TRACER_NBR - Bank Tracer Nbr
      TRANS_FEE_CD - Transaction Fee Code
      TRANSFER_AMT - Transfer Amt
      TRANSFER_DT - Transfer Date
      TRANSFER_PAYMNT_ID - Transfer Payment ID
      TRANSFER_STATUS - Transfer Status
      WAIVER_CODE - Waiver Code

 Item Type Tbl - Item Type Table
 Y    EFFDT - Effective Date
 Y    ITEM_TYPE - Item Type
 Y    SETID - SetID
      ACCTG_DT_CNTL - Accounting Date Control
      ADJUSTMENT_CAL_SF - Adjustment Calendar
      ALL_OR_NONE - Pay All or None
      CHARGE_PRIORITY - Charge Priority List
      CURRENCY_CD - Currency Code
      DAYS_SINCE_EFFDT - Days Past Since Effdt
      DAYS_TO_EFFDT - Days to Effdt
      DEFAULT_AMT - Default Amount
      DESCR - Description
      DESCRSHORT - Short Description
      DUEDAYS_PAST_EFFDT - Nbr of Days Past Effdt
      DUEDAYS_PRIOR_EFFD - Nbr of Days Before Effdt
      EFF_STATUS - Status as of Effective Date
      ENCUMBRANCE_DAYS - Days to Encumber
      ENCUMBRANCE_PCT - Encumbrance Pct
      ENROL_FLAG - Enrolled Flag
      ERNCD - Earnings Code
      ERNCD_NOTAX - Earnings Code Non Taxable
      GL_CRSE_CLASS_SPC - Course Class Specific
      GL_INTERFACE_REQ - GL Interface Required
      ITEM_TYPE_CD - Item Type Code
      KEYWORD1 - Key Word
      KEYWORD2 - Key Word 2
      KEYWORD3 - Key Word 3


07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
      LOCAL_TAX_OFFSET - Local Tax Offset
      LOCAL_TAX_PMT - Local Tax Payment
      MATCH_WRITEOFF - Match Charge Write-Offs
      MAXIMUM_AMT - Maximum Transaction Amount
      MINIMUM_AMT - Mininum Transaction Amount
      NRA_CREDIT_TAX_FLG - NRA Tax Payment Flag
      NRA_DEBIT_TAX_FLG - NRA Tax Type
      PAY_PRIORITY_ID - Payment Overall Priority
      PAYMENT_PRIORITY - Payment Priority
      PAYMENT_TERMS - Payment Terms
      PRIORITY - Priority
      PRIORITY_PMT_FLG - Payment Priority Flag
      RECVABLE_FROM_CHRG - Pick up Receivable from Charge
      REFUNDABLE_IND - Refundable Indicator
      SECURITY_GROUP - Security Group
      SF_1098_FLG - 1098-T Eligible
      SSF_DEST_TUT_TYPE - DEST Tuition Type
      SSF_STATE_FLAG - State
      STATE_TAX_OFFSET - State Tax Offset
      STATE_TAX_PMT - State Tax Payment
      T2202A_FLG - T2202A Eligible
      T2202A_OFFSET_FLG - T2202A Offset
      T2202A_PCT - T2202A Percent
      T4_INCOME - T4A Eligible
      TAX_CD - Tax Code
      TAXABLE_Y_N - Taxable
      TENDER_CATEGORY - Tender Category
      TENDER_SPEC - Tender Specific
      TERM_ENROLL_REQ - Term Enroll Req for Posting
      TUITION_DEPOSIT - Tuition Deposit
      WAGE_LOSS_PLAN - Wage Loss Replacement Plan

 Item Type Vw - Item Type View
      Y   SETID - SetID
      Y   ITEM_TYPE - Item Type
          DESCR - Description

 SF Acctg Ln - SF Accounting Line Table
      Y   RUN_DT - Run Date
      Y   SEQNUM - Sequence number
      Y   SF_LINE_NBR - Line Number
          ACCOUNT - Account
          ACCOUNTING_DT - Accounting Date
          ACCOUNTING_PERIOD - Accounting Period
          AFFILIATE - Affiliate
          AFFILIATE_INTRA1 - Fund Affiliate
          AFFILIATE_INTRA2 - Operating Unit Affiliate
          ALTACCT - Alternate Account
          APPL_JRNL_ID - Journal Template
          AUDIT_ACTN - Action
          BUDGET_PERIOD - Budget Period


07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
          BUDGET_REF - Budget Reference
          BUSINESS_UNIT - Business Unit
          BUSINESS_UNIT_GL - General Ledger Unit
          CHARTFIELD1 - Chartfield 1
          CHARTFIELD2 - Chartfield 2
          CHARTFIELD3 - Chartfield 3
          CLASS_FLD - Class Field
          COMMON_ID - ID
          CURRENCY_CD - Currency Code
          DEPTID - Department
          EMPLID - EmplID
          EXT_GL_CHARTFLD - External GL Chart Field
          FISCAL_YEAR - Fiscal Year
          FOREIGN_AMOUNT - Foreign Amount
          FOREIGN_CURRENCY - Foreign Currency Code
          FUND_CODE - Fund Code
          GL_DISTRIB_STATUS - Distribution Status
          IN_PROCESS_FLG - In Process
          ITEM_NBR - Item Nbr
          JOURNAL_DATE - Journal Date
          JOURNAL_ID - GL Journal ID
          JOURNAL_LINE - GL Journal Line Number
          JOURNAL_LINE_DATE - Journal Line Date
          JRNL_LINE_STATUS - Journal Line Status
          JRNL_LN_REF - Journal Line Reference
          LEDGER - Ledger
          LEDGER_GROUP - Ledger Group
          LINE_DESCR - Journal Line Description
          MONETARY_AMOUNT - Monetary Amount
          OPEN_ITEM_STATUS - Open Item Status
          OPERATING_UNIT - Operating Unit
          PROCESS_INSTANCE - Process Instance
          PRODUCT - Product
          PROGRAM_CODE - Program Code
          PROJECT_ID - Project/Grant
          RATE_DIV - Rate Divisor
          RATE_MULT - Rate Multiplier
          RT_TYPE - Rate Type
          SA_ID_TYPE - ID Type
          SF_DEPOSIT_ID - Deposit ID
          SF_EXT_ORG_ID - External Org ID
          SF_GL_RUN_INSTANCE - Process Instance
          STATISTIC_AMOUNT - Statistic Amount
          STATISTICS_CODE - Statistics Code




07/07/2008
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
                                                      ITEM_SF CALCULATIONS

ACCOUNT TYPE SF DECODE                                                                           ACCOUNT TYPE SF DECODE SORT
       CASE
       WHEN Account Type SF = 'ADM'                      THEN 'Admission Fees'
       WHEN Account Type SF = 'CNV'                      THEN 'Converson Balance from ISIS'
       WHEN Account Type SF = 'END'                      THEN 'Enrollment Deposits Paid'               UMS01
       WHEN Account Type SF = 'ENR'                      THEN 'Enrollment Fees'
       WHEN Account Type SF = 'MCF'                      THEN 'Misc Charges and Fines'
       WHEN Account Type SF = 'OTH'                      THEN 'Other'
       WHEN Account Type SF = 'PP'                       THEN 'Payment Plans'                          UMS01
       WHEN Account Type SF = 'PPL'                      THEN 'Payment Plans'
       WHEN Account Type SF = 'PRL'                      THEN 'Payroll Deduction Payment Plan'         UMS03,UMS04,UMS07
       WHEN Account Type SF = 'RMB'                      THEN 'Room and Board'
       WHEN Account Type SF = 'SCH'                      THEN 'Scholarships'                           UMS01
       WHEN Account Type SF = 'SPN'                      THEN 'Sponsored Charges'
       WHEN Account Type SF = 'TUT'                      THEN 'Tuition'
       WHEN Account Type SF = 'UND'                      THEN 'Undefined Postings'
       WHEN Account Type SF = 'XCP'                      THEN 'Cross Campus Account'
       WHEN Account Type SF = 'XFA'                      THEN 'Excess Financial Aid'
       WHEN Account Type SF = 'XPY'                      THEN 'Excess Payments'
       WHEN Account Type SF = 'XWA'                      THEN 'Excess Waivers'                         UMS06
       WHEN Account Type SF = 'XWV'                      THEN 'Excess Waiver Account'                  UMS01,UMS02,UMS03,UMS04,UMS05,UMS07
                                                         ELSE 'Other'
       END




   5/2/2010
   D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
                                                       ITEM_SF CALCULATIONS

ITEM TYPE CD DECODE                                                                      ITEM TYPE CD DECODE SORT
        CASE
        WHEN Item Type Cd = 'A'                           THEN 'Application Fee'
        WHEN Item Type Cd = 'B'                           THEN 'Billing Only'
        WHEN Item Type Cd = 'C'                           THEN 'Charge'
        WHEN Item Type Cd = 'D'                           THEN 'Deposit'
        WHEN Item Type Cd = 'F'                           THEN 'Financial Aid'
        WHEN Item Type Cd = 'G'                           THEN 'GL Interface Only'
        WHEN Item Type Cd = 'H'                           THEN 'Withholding'
        WHEN Item Type Cd = 'I'                           THEN 'Interest'
        WHEN Item Type Cd = 'L'                           THEN 'Pre-Paid Tuition'
        WHEN Item Type Cd = 'P'                           THEN 'Payment'
        WHEN Item Type Cd = 'R'                           THEN 'Refund'
        WHEN Item Type Cd = 'T'                           THEN 'Transfers'
        WHEN Item Type Cd = 'V'                           THEN 'Contributor Relations'
        WHEN Item Type Cd = 'W'                           THEN 'Waiver'
        WHEN Item Type Cd = 'X'                           THEN 'Write-off'
        WHEN Item Type Cd = 'Z'                           THEN 'Pay Plan Credit'
                                                          ELSE 'Other'
        END

AGING CALCULATIONS

        FUTURE DUE
        SUM (CASE WHEN Age Category = '01' THEN Amount ELSE 0 END)

        0 - 60 DAYS
        SUM (CASE WHEN Age Category = '02' THEN Amount ELSE 0 END)

        61 - 90 DAYS
        SUM (CASE WHEN Age Category = '03' THEN Amount ELSE 0 END)

        91 - 120 DAYS
        SUM (CASE WHEN Age Category = '04' THEN Amount ELSE 0 END)

        121 - 180 DAYS

    5/2/2010
    D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls
                                                   ITEM_SF CALCULATIONS

    SUM (CASE WHEN Age Category = '05' THEN Amount ELSE 0 END)

    181 - 365 DAYS
    SUM (CASE WHEN Age Category = '06' THEN Amount ELSE 0 END)

    366 - 731 DAYS
    SUM (CASE WHEN Age Category = '07' THEN Amount ELSE 0 END)

    732 - 1095 DAYS
    SUM (CASE WHEN Age Category = '08' THEN Amount ELSE 0 END)

    Over 1095 DAYS
    SUM (CASE WHEN Age Category = '09' THEN Amount ELSE 0 END)




5/2/2010
D:\Docstoc\Working\pdf\12c0ed97-7aa4-4068-8b78-0351eebad370.xls

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:1292
posted:5/3/2010
language:English
pages:66