DWStaging
 dbo.AR_STANDARD_TABLES_A (Table)
Home  Diagrams  Documents  Images  DWStaging  Storage  Users  Roles  Schemas  Tables  Views  Indexes  Triggers  Stored Procedures  Functions  Data Types  XML Schemas  Rules  Defaults  Fulltext Catalogs  Synonyms  Keys  Partitions  Assemblies 
Current Path:  DWStaging   Tables   dbo.AR_STANDARD_TABLES_A
  Properties
Property Value
Name AR_STANDARD_TABLES_A
Schema dbo
Row Count 13438
Data Size 2208 KB
Index Size 248 KB
Create Date 11/7/2012 11:53 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ADD_DATE
varchar(8)
True
False
False
 
ADD_PGM
varchar(8)
True
False
False
 
ADD_TIME
varchar(7)
True
False
False
 
ADD_USER_ID
varchar(8)
True
False
False
 
ADDITIONAL_CHGS_INDICATOR
varchar(1)
True
False
False
 
ALL_EFT_TO_ONE_BANK_IND
varchar(1)
True
False
False
 
ALLOW_BOOKSTORE_RECEIVABLES
bit(1, 0)
True
False
False
 
ALLOW_NEW_DISBURSEMENTS
varchar(1)
True
False
False
 
ALLOW_PARTIAL_PAYMENT
varchar(1)
True
False
False
 
AMT_REQUIRED_INDICATOR
varchar(1)
True
False
False
 
AR_CHECK_HOLD_DAYS
int(10, 0)
True
False
False
 
AR_CHECK_INTL_HOLD_DAYS
int(10, 0)
True
False
False
 
AR_CHECK_OUT_STATE_HOLD_DAYS
int(10, 0)
True
False
False
 
AWARD_END_TERM
varchar(6)
True
False
False
 
AWARD_ONLY_IND
varchar(1)
True
False
False
 
AWARD_START_TERM
varchar(6)
True
False
False
 
BALANCE_ACCT
varchar(25)
True
False
False
 
BANK_CODE
varchar(4)
True
False
False
 
BANK_LIABILITY_ACCT
varchar(25)
True
False
False
 
BOOKSTORE_CUSTOMER_ID
varchar(9)
True
False
False
 
BOOKSTORE_INST_CHARGES_IND
varchar(1)
True
False
False
 
BOOKSTORE_RECEIVABLE
bit(1, 0)
True
False
False
 
BOOKSTORE_RECEIVABLES_TERM
varchar(6)
True
False
False
 
CA_CUSTOMER_OBLIGATION
varchar(2)
True
False
False
 
CA_CUSTOMER_PAYMENT_DAYS
int(10, 0)
True
False
False
 
CA_OBLIGATION_WARNING
varchar(1)
True
False
False
 
CA_STUDENT_OBLIGATION
varchar(2)
True
False
False
 
CA_STUDENT_PAYMENT_DAYS
int(10, 0)
True
False
False
 
CASH_OVER_SHORT_ACCOUNT_NBR
varchar(25)
True
False
False
 
CHANGE_ALLOWED_ON_CHECK
varchar(1)
True
False
False
 
COLLEGE_EXTENSION
varchar(5)
True
False
False
 
COLLEGE_NAME
varchar(40)
True
False
False
 
COLLEGE_PHONE_NBR
varchar(10)
True
False
False
 
COMMENT_IND
varchar(1)
True
False
False
 
CONTACT_NAME
varchar(4)
True
False
False
 
CONTRACT_CATEGORY
varchar(2)
True
False
False
 
COVERAGE_ADJ_AMT_ACCT
varchar(25)
True
False
False
 
COVERAGE_REC
varchar(10)
True
False
False
 
COVERAGE_TYPES
varchar(15)
True
False
False
 
CREATE_AUTO_CONTRACTS
bit(1, 0)
True
False
False
 
CREATE_CONTRACTS
bit(1, 0)
True
False
False
 
CREDIT_CARD_LIABILITY_ACCT
varchar(25)
True
False
False
 
CUSTOMER_BANK_ACCT
varchar(25)
True
False
False
 
CUSTOMER_ID
varchar(9)
True
False
False
 
CUSTOMER_STOP_IND
varchar(1)
True
False
False
 
DEFAULT_RECEIVABLE_TYPE
varchar(2)
True
False
False
 
DEPARTMENT_NAME
varchar(40)
True
False
False
 
DISBURSE_TO_BOOKSTORE
bit(1, 0)
True
False
False
 
DISBURSE_TO_BOOKSTORE_SEQ
int(10, 0)
True
False
False
 
DISBURSE_TO_CUSTOMER_RECV
bit(1, 0)
True
False
False
 
DISBURSE_TO_CUSTOMER_RECV_SEQ
int(10, 0)
True
False
False
 
DISBURSE_TO_FEES
bit(1, 0)
True
False
False
 
DISBURSE_TO_NRA_TAXABLE_SEQ
int(10, 0)
True
False
False
 
DISBURSE_TO_OBLIGATIONS
bit(1, 0)
True
False
False
 
DISBURSE_TO_OBLIGATIONS_SEQ
int(10, 0)
True
False
False
 
DISBURSE_TO_OTHER_RECV
bit(1, 0)
True
False
False
 
DISBURSE_TO_OTHER_RECV_SEQ
int(10, 0)
True
False
False
 
DISBURSE_TO_STUDENT_RECV_SEQ
int(10, 0)
True
False
False
 
DISBURSE_TO_TAX
bit(1, 0)
True
False
False
 
DISBURSEMENT_ONLY
bit(1, 0)
True
False
False
 
EFF_DATE
varchar(8)
True
False
False
 
EFF_TERM
varchar(6)
True
False
False
 
END_DATE
varchar(8)
True
False
False
 
END_TERM
varchar(6)
True
False
False
 
FA_CALC_COVERAGE_DUE
bit(1, 0)
True
False
False
 
FA_CUSTOMER_ID
varchar(9)
True
False
False
 
FA_LOAN_NET
varchar(1)
True
False
False
 
FA_OFFERED_ACCEPTED
varchar(1)
True
False
False
 
FA_OVERPAYMENT_RECEIVABLE_TYPE
varchar(2)
True
False
False
 
FA_POSITION_CODE
varchar(8)
True
False
False
 
FA_RECV_TYPE_CUSTOMER
varchar(2)
True
False
False
 
FA_RECV_TYPE_STUDENT
varchar(2)
True
False
False
 
FA_UPDATE_CONDITIONS
bit(1, 0)
True
False
False
 
FEDERAL_AID_AUTHORIZATION_FLAG
varchar(1)
True
False
False
 
FEE_DEFICIENCY_CUSTOMER_ID
varchar(9)
True
False
False
 
FINANCIAL_AID_GROUP_CODE
varchar(10)
True
False
False
 
FINANCIAL_AID_KEY
varchar(20)
True
False
False
 
FINANCIAL_HOLD_FLAG
varchar(1)
True
False
False
 
FN_NON_RESIDUAL_CUSTOMER_ID
varchar(9)
True
False
False
 
FN_RESIDUAL_CUSTOMER_ID
varchar(9)
True
False
False
 
FOUNDATION_OFFSET_ACCT
varchar(25)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
IMMEDIATE_FINANCIAL_HOLD
varchar(1)
True
False
False
 
ISN_AR_STANDARD_TABLES_A
int(10, 0)
False
False
False
 
MAINT_DATE
varchar(8)
True
False
False
 
MAINT_PGM
varchar(8)
True
False
False
 
MAINT_TIME
varchar(7)
True
False
False
 
MAINT_USER_ID
varchar(8)
True
False
False
 
MAX_AMT
numeric(17, 2)
True
False
False
 
MAX_RECEIPTS_PER_SESSION
int(10, 0)
True
False
False
 
MAXIMUM_AMOUNT_CHANGE
numeric(17, 2)
True
False
False
 
MINIMUM_CREDIT_CARD_REFUND_AMT
numeric(17, 2)
True
False
False
 
MINIMUM_FA_TO_AP_AMT
numeric(17, 2)
True
False
False
 
MINIMUM_REFUND_TO_AP_AMT
numeric(17, 2)
True
False
False
 
NON_STANDARD_RECV_FLAG
varchar(1)
True
False
False
 
OBL_ACCOUNT_NBR
varchar(25)
True
False
False
 
OBLG_HOLD_TYPE
varchar(2)
True
False
False
 
OBLG_NEEDS_BILLED_IND
varchar(2)
True
False
False
 
OBLG_NONTAXABLE_IND
varchar(1)
True
False
False
 
OBLIGATION_DESCRIPTION
varchar(30)
True
False
False
 
OBLIGATION_TYPE
varchar(2)
True
False
False
 
OFFSET_ACCT_REQ_FLAG
varchar(1)
True
False
False
 
OVERIDE_FLAG
varchar(1)
True
False
False
 
OVERPAY_LIABILITY_ACCT
varchar(25)
True
False
False
 
PAY_FUTURE_TERM_IND
varchar(1)
True
False
False
 
PAY_PRIOR_TERM_IND
varchar(1)
True
False
False
 
PAY_WITH_FINANCIAL_AID
varchar(1)
True
False
False
 
PERCENT_COVERAGE
numeric(17, 4)
True
False
False
 
PROVIDES_COVERAGE_INDICATOR
varchar(1)
True
False
False
 
RECEIVABLE_DESCRIPTION
varchar(30)
True
False
False
 
RECEIVABLE_TYPE
varchar(2)
True
False
False
 
RECV_ACCT_REQ_FLAG
varchar(1)
True
False
False
 
RECV_FINANCIAL_HOLD_FLAG
varchar(1)
True
False
False
 
RECV_HOLD_TYPE
varchar(2)
True
False
False
 
RECV_NONTAXABLE_IND
varchar(1)
True
False
False
 
REDUCE_AWARD_PERCENT
numeric(17, 2)
True
False
False
 
REFUND_HOLD_IND
varchar(1)
True
False
False
 
REFUND_TO_STUD_OBLG_SEQ
int(10, 0)
True
False
False
 
REFUND_TO_STUD_RECV_SEQ
int(10, 0)
True
False
False
 
REFUND_TO_STUDENT
bit(1, 0)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
STUDENT_STOP_IND
varchar(1)
True
False
False
 
SYSTEM_PROFILE_REC
varchar(10)
True
False
False
 
T1098_EXCLUDE_IND
varchar(1)
True
False
False
 
TAXABLE_FUND_IND
varchar(1)
True
False
False
 
TERM_REQUIRED_INDICATOR
varchar(1)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_AR_STANDARD_TABLES_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.AR_STANDARD_TABLES_A depends on)
Name Type
View
View
  Child Dependencies (objects that depend on dbo.AR_STANDARD_TABLES_A)
Name Type
VIEW
VIEW
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[AR_STANDARD_TABLES_A] Script Date: 03/09/2017 16:45:01 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[AR_STANDARD_TABLES_A](
    [ISN_AR_STANDARD_TABLES_A] [int] NOT NULL,
    [ADD_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOLD] [int] NULL,
    [RECEIVABLE_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECEIVABLE_DESCRIPTION] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECV_ACCT_REQ_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OFFSET_ACCT_REQ_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NON_STANDARD_RECV_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADDITIONAL_CHGS_INDICATOR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PROVIDES_COVERAGE_INDICATOR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TERM_REQUIRED_INDICATOR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COVERAGE_TYPES] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OBLIGATION_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OBLIGATION_DESCRIPTION] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AMT_REQUIRED_INDICATOR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OBL_ACCOUNT_NBR] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FINANCIAL_HOLD_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OVERIDE_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COVERAGE_REC] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECV_FINANCIAL_HOLD_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECV_HOLD_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OBLG_NEEDS_BILLED_IND] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OBLG_HOLD_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SYSTEM_PROFILE_REC] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COLLEGE_NAME] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DEPARTMENT_NAME] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COLLEGE_PHONE_NBR] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COLLEGE_EXTENSION] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BANK_LIABILITY_ACCT] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OVERPAY_LIABILITY_ACCT] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_STOP_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CUSTOMER_STOP_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTACT_NAME] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CHANGE_ALLOWED_ON_CHECK] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAXIMUM_AMOUNT_CHANGE] [numeric](17, 2) NULL,
    [MAX_RECEIPTS_PER_SESSION] [int] NULL,
    [IMMEDIATE_FINANCIAL_HOLD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FINANCIAL_AID_KEY] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CUSTOMER_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DEFAULT_RECEIVABLE_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FEE_DEFICIENCY_CUSTOMER_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ALLOW_BOOKSTORE_RECEIVABLES] [bit] NULL,
    [BOOKSTORE_CUSTOMER_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FA_RECV_TYPE_CUSTOMER] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CREATE_CONTRACTS] [bit] NULL,
    [CREATE_AUTO_CONTRACTS] [bit] NULL,
    [FA_CUSTOMER_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BOOKSTORE_RECEIVABLE] [bit] NULL,
    [DISBURSEMENT_ONLY] [bit] NULL,
    [BOOKSTORE_RECEIVABLES_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FA_OVERPAYMENT_RECEIVABLE_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ALLOW_NEW_DISBURSEMENTS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DISBURSE_TO_FEES] [bit] NULL,
    [DISBURSE_TO_OTHER_RECV] [bit] NULL,
    [DISBURSE_TO_BOOKSTORE] [bit] NULL,
    [FA_POSITION_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CASH_OVER_SHORT_ACCOUNT_NBR] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTRACT_CATEGORY] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AR_CHECK_HOLD_DAYS] [int] NULL,
    [MAX_AMT] [numeric](17, 2) NULL,
    [PERCENT_COVERAGE] [numeric](17, 4) NULL,
    [CREDIT_CARD_LIABILITY_ACCT] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BALANCE_ACCT] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFF_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFF_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [END_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DISBURSE_TO_OBLIGATIONS] [bit] NULL,
    [DISBURSE_TO_CUSTOMER_RECV] [bit] NULL,
    [FINANCIAL_AID_GROUP_CODE] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_WITH_FINANCIAL_AID] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REFUND_TO_STUDENT] [bit] NULL,
    [AWARD_START_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FA_RECV_TYPE_STUDENT] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FA_OFFERED_ACCEPTED] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FA_UPDATE_CONDITIONS] [bit] NULL,
    [REDUCE_AWARD_PERCENT] [numeric](17, 2) NULL,
    [FA_CALC_COVERAGE_DUE] [bit] NULL,
    [AWARD_END_TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AR_CHECK_INTL_HOLD_DAYS] [int] NULL,
    [AR_CHECK_OUT_STATE_HOLD_DAYS] [int] NULL,
    [REFUND_HOLD_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MINIMUM_REFUND_TO_AP_AMT] [numeric](17, 2) NULL,
    [MINIMUM_FA_TO_AP_AMT] [numeric](17, 2) NULL,
    [CUSTOMER_BANK_ACCT] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COVERAGE_ADJ_AMT_ACCT] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COMMENT_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DISBURSE_TO_OTHER_RECV_SEQ] [int] NULL,
    [DISBURSE_TO_STUDENT_RECV_SEQ] [int] NULL,
    [DISBURSE_TO_CUSTOMER_RECV_SEQ] [int] NULL,
    [DISBURSE_TO_BOOKSTORE_SEQ] [int] NULL,
    [DISBURSE_TO_OBLIGATIONS_SEQ] [int] NULL,
    [REFUND_TO_STUD_RECV_SEQ] [int] NULL,
    [REFUND_TO_STUD_OBLG_SEQ] [int] NULL,
    [PAY_FUTURE_TERM_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ALL_EFT_TO_ONE_BANK_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_PRIOR_TERM_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MINIMUM_CREDIT_CARD_REFUND_AMT] [numeric](17, 2) NULL,
    [BANK_CODE] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BOOKSTORE_INST_CHARGES_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AWARD_ONLY_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FN_RESIDUAL_CUSTOMER_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FN_NON_RESIDUAL_CUSTOMER_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FOUNDATION_OFFSET_ACCT] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CA_STUDENT_OBLIGATION] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CA_CUSTOMER_OBLIGATION] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CA_STUDENT_PAYMENT_DAYS] [int] NULL,
    [CA_CUSTOMER_PAYMENT_DAYS] [int] NULL,
    [CA_OBLIGATION_WARNING] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [T1098_EXCLUDE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FA_LOAN_NET] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECV_NONTAXABLE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OBLG_NONTAXABLE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TAXABLE_FUND_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DISBURSE_TO_NRA_TAXABLE_SEQ] [int] NULL,
    [DISBURSE_TO_TAX] [bit] NULL,
    [ALLOW_PARTIAL_PAYMENT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FEDERAL_AID_AUTHORIZATION_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID ADDITIONAL_CHGS_INDICATOR ALL_EFT_TO_ONE_BANK_IND ALLOW_BOOKSTORE_RECEIVABLES ALLOW_NEW_DISBURSEMENTS ALLOW_PARTIAL_PAYMENT AMT_REQUIRED_INDICATOR AR_CHECK_HOLD_DAYS AWARD_END_TERM AWARD_ONLY_IND AWARD_START_TERM BALANCE_ACCT BANK_CODE BANK_LIABILITY_ACCT BOOKSTORE_CUSTOMER_ID BOOKSTORE_INST_CHARGES_IND BOOKSTORE_RECEIVABLE BOOKSTORE_RECEIVABLES_TERM CA_CUSTOMER_OBLIGATION CA_OBLIGATION_WARNING CA_STUDENT_OBLIGATION CASH_OVER_SHORT_ACCOUNT_NBR CHANGE_ALLOWED_ON_CHECK COLLEGE_EXTENSION COLLEGE_NAME COLLEGE_PHONE_NBR COMMENT_IND CONTACT_NAME CONTRACT_CATEGORY COVERAGE_ADJ_AMT_ACCT COVERAGE_REC COVERAGE_TYPES CREATE_AUTO_CONTRACTS CREATE_CONTRACTS CREDIT_CARD_LIABILITY_ACCT CUSTOMER_BANK_ACCT CUSTOMER_ID CUSTOMER_STOP_IND DEFAULT_RECEIVABLE_TYPE DEPARTMENT_NAME DISBURSE_TO_BOOKSTORE DISBURSE_TO_CUSTOMER_RECV DISBURSE_TO_FEES DISBURSE_TO_OBLIGATIONS DISBURSE_TO_OTHER_RECV DISBURSE_TO_TAX DISBURSEMENT_ONLY EFF_DATE EFF_TERM END_DATE END_TERM FA_CALC_COVERAGE_DUE FA_CUSTOMER_ID FA_LOAN_NET FA_OFFERED_ACCEPTED FA_OVERPAYMENT_RECEIVABLE_TYPE FA_POSITION_CODE FA_RECV_TYPE_CUSTOMER FA_RECV_TYPE_STUDENT FA_UPDATE_CONDITIONS FEDERAL_AID_AUTHORIZATION_FLAG FEE_DEFICIENCY_CUSTOMER_ID FINANCIAL_AID_GROUP_CODE FINANCIAL_AID_KEY FINANCIAL_HOLD_FLAG FN_NON_RESIDUAL_CUSTOMER_ID FN_RESIDUAL_CUSTOMER_ID FOUNDATION_OFFSET_ACCT HOLD IMMEDIATE_FINANCIAL_HOLD ISN_AR_STANDARD_TABLES_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MAX_AMT NON_STANDARD_RECV_FLAG OBL_ACCOUNT_NBR OBLG_HOLD_TYPE OBLG_NEEDS_BILLED_IND OBLG_NONTAXABLE_IND OBLIGATION_DESCRIPTION OBLIGATION_TYPE OFFSET_ACCT_REQ_FLAG OVERIDE_FLAG OVERPAY_LIABILITY_ACCT PAY_FUTURE_TERM_IND PAY_PRIOR_TERM_IND PAY_WITH_FINANCIAL_AID PROVIDES_COVERAGE_INDICATOR RECEIVABLE_DESCRIPTION RECEIVABLE_TYPE RECV_ACCT_REQ_FLAG RECV_FINANCIAL_HOLD_FLAG RECV_HOLD_TYPE RECV_NONTAXABLE_IND REFUND_HOLD_IND REFUND_TO_STUDENT RowUpdatedOn STUDENT_STOP_IND SYSTEM_PROFILE_REC T1098_EXCLUDE_IND TAXABLE_FUND_IND TERM_REQUIRED_INDICATOR
20040610 FIC182B2 1022575 E005840 false Y 0 N false FI true false 000000916 true true true true true false false false false 2005PBPDFLSTFAI 1137328 1898 20040610 FIC180N1 1137328 E005840 2500.00 false 2017-02-06T11:26:04.873-05:00 N
20140611 FIC182B2 0629499 E005840 false Y 0 N false FI true false 000001107 true true true true true false false false false 2015PBPBCCSTAYL 9200 5000.00 false 2017-02-06T11:26:06.62-05:00 N
20110606 FIC182B2 0848527 E005840 false Y 0 N false FI true false 000001132 true true true true true false false false false 2012PBPDNEWHAMP 6641 5000.00 false 2017-02-06T11:26:06.012-05:00
20100604 FIC182B2 1937046 E005840 false Y 0 N false FI true false 000000255 true true true true true false false false false 2011PBPDROTPB 5821 2000.00 false 2017-02-06T11:26:05.809-05:00 N
20170131 FIC182B2 1024263 ZCEAL false Y 0 N false FI true false 000001824 true true true true true false false false false 2018PBPDNAPLES 13099 5000.00 false 2017-02-06T11:26:07.572-05:00 N
20060607 FIC182B2 1109126 E031488 false Y 0 N false FI true false 000001212 true true true true true false false false false 2007PBPDPBCTEAC 2927 2500.00 false 2017-02-06T11:26:05.138-05:00
20050613 FIC182B2 1104070 E005840 false Y 0 N false FI true false 000000242 true true true true true false false false false 2006PBPDLWBUSIN 2466 1400.00 false 2017-02-06T11:26:05.014-05:00
20090430 FIC182B2 1055042 E031488 false Y 0 N false FI true false 000000645 true true true true true false false false false 2010PBPDPBNEWSP 4965 1400.00 false 2017-02-06T11:26:05.606-05:00
20101104 FIC180N1 1510362 E021320 false Y 0 N false FI true false 000001802 FB false true true true true false true false FOUNDRS01 false 2011PBFDJFKMD 1512221 5991 20101104 FIC180N1 1512221 E021320 5000.00 false 2017-02-06T11:26:05.84-05:00 N
20090430 FIC182B2 1055026 E031488 false Y 0 N false FI true false 000001188 FB true true true true true false false false FOUNDRS01 false 2010PBFDBOCABEA 4452 5000.00 false 2017-02-06T11:26:05.482-05:00 N
Powered by BI Documenter