Source for Predefined Datasets

The following table lists the source from where data is gathered for the respective dataset:
Dataset Name Module Dataset Table Source Tables
Group Invoice Account C1_​DIM_​ACCT_​INTG

CI_​ACCT, CI_​ACCT_​PER, CI_​ACCT_​NBR,

CI_​ACCT_​APAY, CI_​ACCT_​MSG, CI_​PER,

CI_​PER_​NAME, CI_​BILL_​MSG_​L
Bills C1_​BILL_​FACT_​INTG CI_​BILL
Billing Group C1_​GRP_​MEM_​INTG

CI_​POLICY, CI_​POLICY_​PER,

C1_​BILL_​LVL, CI_​MEMBERSHIP,

CI_​MEMBERSHIP_​PER, CI_​POLICY_​PLAN,

CI_​ACCT_​PER, CI_​PER, CI_​PER_​NAME,

CI_​PRICEITEM_​L, CI_​SA_​REL_​TYPE_​L
Bill Segment C1_​BSEG_​DTLS_​INTG

CI_​BSEG, CI_​BSEG_​EXT, CI_​BSEG_​CALC,

CI_​BSEG_​CALC_​LN
Financial Transaction C1_​FT_​GL_​DTLS_​INTG

CI_​FT, CI_​FT_​GL, C1_​FT_​EXT,

C1_​FT_​GL_​EXT, CI_​SA
Group Membership C1_​GRP_​MEM_​INTG

CI_​POLICY, CI_​POLICY_​PER,

C1_​BILL_​LVL, CI_​MEMBERSHIP,

CI_​MEMBERSHIP_​PER, CI_​POLICY_​PLAN,

CI_​ACCT_​PER, CI_​PER, CI_​PER_​NAME,

CI_​PRICEITEM_​L, CI_​SA_​REL_​TYPE_​L
Membership Person C1_​GRP_​MEM_​INTG

CI_​POLICY, CI_​POLICY_​PER,

C1_​BILL_​LVL, CI_​MEMBERSHIP,

CI_​MEMBERSHIP_​PER, CI_​POLICY_​PLAN,

CI_​ACCT_​PER,CI_​PER, CI_​PER_​NAME,

CI_​PRICEITEM_​L, CI_​SA_​REL_​TYPE_​L
Policy Holder C1_​GRP_​MEM_​INTG

CI_​POLICY, CI_​POLICY_​PER,

C1_​BILL_​LVL, CI_​MEMBERSHIP,

CI_​MEMBERSHIP_​PER, CI_​POLICY_​PLAN,

CI_​ACCT_​PER, CI_​PER, CI_​PER_​NAME,

CI_​PRICEITEM_​L, CI_​SA_​REL_​TYPE_​L
ASO Invoice Account C1_​DIM_​ACCT_​INTG

CI_​ACCT, CI_​ACCT_​PER,

CI_​ACCT_​NBR, CI_​ACCT_​APAY,

CI_​ACCT_​MSG, CI_​PER,

CI_​PER_​NAME, CI_​BILL_​MSG_​L
ASL Details C1_​ASL_​DTLS_​INTG

CI_​ACCUM_​GRP, CI_​ACCUM_​ASL_​AMT,

CI_​ACCUM_​GRP_​ASL, CI_​POLICY,

CI_​POLICY_​PER, CI_​ACCT_​PER,

CI_​ACCT, CI_​PER,

CI_​PER_​ID, CI_​PER_​PER,

CI_​ID_​TYPE_​L, CI_​PER_​NAME,

CI_​CIS_​DIVISION_​L, CI_​CURRENCY_​CD_​L,

CI_​CURRENCY_​CD, C1_​PRC_​RULE,

CI_​LOOKUP_​VAL_​L
Bills C1_​BILL_​FACT_​INTG CI_​BILL
Bill Segment C1_​BSEG_​DTLS_​INTG

CI_​BSEG, CI_​BSEG_​EXT, CI_​BSEG_​CALC,

CI_​BSEG_​CALC_​LN
Financial Transaction C1_​FT_​GL_​DTLS_​INTG

CI_​FT, CI_​FT_​GL,

C1_​FT_​EXT, C1_​FT_​GL_​EXT, CI_​SA
Customer C1_​DIM_​CUST_​INTG

CI_​PER, CI_​PER_​NAME,

CI_​PER_​EMPLOYMENT_​DTLS,

CI_​PER_​PHONE, CI_​PER_​PER
SSL Details C1_​SSL_​DTLS_​INTG

CI_​PER, CI_​PER_​NAME, CI_​PER_​PER,

CI_​PER_​ID, CI_​ACCT, CI_​ACCT_​PER,

C1_​BILL_​LVL, CI_​ACCUM_​GRP,

CI_​ACCUM_​GRP_​SSL, CI_​LOOKUP_​VAL_​L,

CI_​ACCUM_​SSL_​AMT,

CI_​ACCUM_​GRP_​SL_​LASER_​EXC,

CI_​ACCUM_​SSL_​MEMBER_​DETAILS,

C1_​ACCUM_​GRP_​MPP,

CI_​CIS_​DIVISION_​L, CI_​CURRENCY_​CD_​L,

CI_​CURRENCY_​CD, CI_​POLICY,

CI_​POLICY_​PER, C1_​PRC_​RULE
Transaction Details C1_​TXN_​DTLS_​INTG

CI_​TXN_​DETAIL, CI_​TXN_​CALC,

CI_​TXN_​CALC_​LN, CI_​TXN_​CALC_​ACCUM_​GRP,

CI_​TXN_​DTL_​PRITM, CI_​TXN_​SQ
Individual Invoice Account C1_​DIM_​ACCT_​INTG

CI_​ACCT, CI_​ACCT_​PER,

CI_​ACCT_​NBR, CI_​ACCT_​APAY,

CI_​ACCT_​MSG, CI_​PER,

CI_​PER_​NAME, CI_​BILL_​MSG_​L
Bills C1_​BILL_​FACT_​INTG CI_​BILL
Bill Segment C1_​BSEG_​DTLS_​INTG

CI_​BSEG, CI_​BSEG_​EXT, CI_​BSEG_​CALC,

CI_​BSEG_​CALC_​LN
Financial Transaction C1_​FT_​GL_​DTLS_​INTG

CI_​FT, CI_​FT_​GL,

C1_​FT_​EXT, C1_​FT_​GL_​EXT, CI_​SA
Customer C1_​DIM_​CUST_​INTG

CI_​PER, CI_​PER_​NAME,

CI_​PER_​EMPLOYMENT_​DTLS, CI_​PER_​PHONE,

CI_​PER_​PER
Individual Membership C1_​IND_​MEM_​INTG

CI_​MEMBERSHIP, CI_​MEMBERSHIP_​PER,

CI_​PER_​NAME, CI_​SA_​REL_​TYPE_​L,

C1_​HEALTH_​PLAN, CI_​PER,

CI_​PER_​ID, CI_​ID_​TYPE_​L,

CI_​CIS_​DIVISION_​L, C1_​PRODUCT_​L,

C1_​PRODUCT_​HC_​DTLS,

CI_​MEMBERSHIP_​RATE_​GUARANTEE,

C1_​PRC_​RULE_​MEMB, C1_​PRC_​RULE
Statements Account C1_​DIM_​ACCT_​INTG

CI_​ACCT, CI_​ACCT_​PER,

CI_​ACCT_​NBR, CI_​ACCT_​APAY,

CI_​ACCT_​MSG, CI_​PER,

CI_​PER_​NAME, CI_​BILL_​MSG_​L
Bills C1_​BILL_​FACT_​INTG CI_​BILL
Bill Segment C1_​BSEG_​DTLS_​INTG

CI_​BSEG, CI_​BSEG_​EXT, CI_​BSEG_​CALC,

CI_​BSEG_​CALC_​LN
Financial Transactions C1_​FT_​GL_​DTLS_​INTG

CI_​FT, CI_​FT_​GL, C1_​FT_​EXT,

C1_​FT_​GL_​EXT, CI_​SA
Customer C1_​DIM_​CUST_​INTG

CI_​PER, CI_​PER_​NAME,

CI_​PER_​EMPLOYMENT_​DTLS, CI_​PER_​PHONE,

CI_​PER_​PER
Statement Accounts C1_​STM_​ACCT_​INTG C1_​DIM_​ACCT_​INTG
Statement Adjustments C1_​STM_​ADJ_​INTG

CI_​ADJ, CI_​FT,

CI_​BILL, C1_​DIM_​ACCT_​INTG
Statement Customers C1_​STM_​PER_​INTG C1_​DIM_​CUST_​INTG, CI_​ACCT_​PER
Statement Services C1_​STM_​SERVICE_​INTG

C1_​BILL_​FACT_​INTG, C1_​FT_​BSEG_​FACT_​INTG,

CI_​B_​CHG_​LINE, CI_​BSEG_​CALC_​LN,

CI_​BILL_​ACH
Transaction Details C1_​TXN_​DTLS_​INTG

CI_​TXN_​DETAIL, CI_​TXN_​CALC,

CI_​TXN_​CALC_​LN, CI_​TXN_​CALC_​ACCUM_​GRP,

CI_​TXN_​DTL_​PRITM, CI_​TXN_​SQ
Adjustment Account C1_​DIM_​ACCT_​INTG

CI_​ACCT, CI_​ACCT_​PER,

CI_​ACCT_​NBR, CI_​ACCT_​APAY,

CI_​ACCT_​MSG, CI_​PER,

CI_​PER_​NAME, CI_​BILL_​MSG_​L
Adjustment C1_​ADJ_​DTLS_​INTG

CI_​ADJ, CI_​ADJ_​CALC_​LN,

CI_​ADJ_​CHAR
Bills C1_​BILL_​FACT_​INTG CI_​BILL
Customer C1_​DIM_​CUST_​INTG

CI_​PER, CI_​PER_​NAME,

CI_​PER_​EMPLOYMENT_​DTLS, CI_​PER_​PHONE,

CI_​PER_​PER
Financial Transaction C1_​FT_​GL_​DTLS_​INTG

CI_​FT, CI_​FT_​GL,

C1_​FT_​EXT, C1_​FT_​GL_​EXT, CI_​SA
Delinquency Account C1_​DIM_​ACCT_​INTG

CI_​ACCT, CI_​ACCT_​PER,

CI_​ACCT_​NBR, CI_​ACCT_​APAY,

CI_​ACCT_​MSG, CI_​PER,

CI_​PER_​NAME, CI_​BILL_​MSG_​L
Bills C1_​BILL_​FACT_​INTG CI_​BILL
Customer C1_​DIM_​CUST_​INTG

CI_​PER, CI_​PER_​NAME,

CI_​PER_​EMPLOYMENT_​DTLS, CI_​PER_​PHONE,

CI_​PER_​PER
Delinquency C1_​DELIN_​DTLS_​INTG

C1_​DELIN_​PROC, C1_​DELIN_​PROC_​EVT,

C1_​DELIN_​PROC_​TYPE_​EVENT,

C1_​DELIN_​PROC_​REL_​OBJ,

C1_​DELIN_​PROC_​HOLD
Financial Transaction Account C1_​DIM_​ACCT_​INTG

CI_​ACCT, CI_​ACCT_​PER,

CI_​ACCT_​NBR, CI_​ACCT_​APAY,

CI_​ACCT_​MSG, CI_​PER,

CI_​PER_​NAME, CI_​BILL_​MSG_​L
Adjustment C1_​ADJ_​DTLS_​INTG CI_​ADJ, CI_​ADJ_​CALC_​LN, CI_​ADJ_​CHAR
Bills C1_​BILL_​FACT_​INTG CI_​BILL
Bill Segment C1_​BSEG_​DTLS_​INTG

CI_​BSEG, CI_​BSEG_​EXT, CI_​BSEG_​CALC,

CI_​BSEG_​CALC_​LN
Customer C1_​DIM_​CUST_​INTG

CI_​PER, CI_​PER_​NAME,

CI_​PER_​EMPLOYMENT_​DTLS,

CI_​PER_​PHONE, CI_​PER_​PER
Financial Transaction C1_​FT_​GL_​DTLS_​INTG

CI_​FT, CI_​FT_​GL, C1_​FT_​EXT,

C1_​FT_​GL_​EXT, CI_​SA
Payment C1_​PAY_​DTLS_​INTG

CI_​PAY, CI_​PAY_​SEG,

CI_​PAY_​TNDR, CI_​PAY_​TNDR_​ST,

CI_​TENDER_​TYPE_​L, CI_​MATCH_​EVT,

CI_​PAY_​EVENT
Payment Account C1_​DIM_​ACCT_​INTG

CI_​ACCT, CI_​ACCT_​PER, CI_​ACCT_​NBR,

CI_​ACCT_​APAY, CI_​ACCT_​MSG,

CI_​PER, CI_​PER_​NAME, CI_​BILL_​MSG_​L
Bills C1_​BILL_​FACT_​INTG CI_​BILL
Customer C1_​DIM_​CUST_​INTG

CI_​PER, CI_​PER_​NAME,

CI_​PER_​EMPLOYMENT_​DTLS, CI_​PER_​PHONE,

CI_​PER_​PER
Financial Transaction C1_​FT_​GL_​DTLS_​INTG

CI_​FT, CI_​FT_​GL, C1_​FT_​EXT,

C1_​FT_​GL_​EXT, CI_​SA
Payment C1_​PAY_​DTLS_​INTG

CI_​PAY, CI_​PAY_​SEG,

CI_​PAY_​TNDR, CI_​PAY_​TNDR_​ST,

CI_​TENDER_​TYPE_​L, CI_​MATCH_​EVT,

CI_​PAY_​EVENT