Get documents about "PS Tables
Document Sample
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
