SGHE Enterprise Data Warehouse
Banner EDW Source: CALCULATION - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| CASE WHEN (RORSTAT_ADDL_PELL_ELIG_IND |
NO |
REPORTING VIEW |
FINAID_APPLICANT_STATUS |
ADDITIONAL_PELL_AWARDS_DESC |
NA |
NO |
| ( TRUNC(SYSDATE) - NVL( CONT_LAST_REC.CONTACT_DATE,TRUNC( SYSDATE)) ); |
NO |
AGGREGATE FACT TABLE |
WAT_STUDENT_PROGRESS |
LAST_CONTACT_DAYS |
STUDENT PROGRESS |
NO |
| ACCT.PAY_CURRENCY_AMOUNT - ACCT.PAY_CURRENCY_AMOUNT_NO_TAX |
NO |
REPORTING VIEW |
REIMBURSEMENT_ACCOUNTING AUTHORIZATION_ACCOUNTING |
PAY_CURRENCY_TAX_AMOUNT PAY_CURRENCY_TAX_AMOUNT |
NA NA |
NO NO |
| CASE STVFFVA_TYPE WHEN |
NO |
|
|
|
|
|
| CASE WHEN (RCRAPP1_SEQ_NO |
NO |
REPORTING VIEW |
FINAID_APPLICANT_STATUS FINAID_APPLICANT_STATUS FINAID_APPLICANT_STATUS |
IM_APPLICATION_IND FINANCIAL_AID_APPLICATION_IND FM_APPLICATION_IND |
NA NA NA |
NO NO NO |
| CASE WHEN ENCUMBRANCE_NUMBER |
NO |
REPORTING VIEW |
ENCUMBRANCE ENCUMBRANCE_ACCOUNTING |
HR_ENCUMBRANCE_IND HR_ENCUMBRANCE_IND |
NA NA |
NO NO |
| CASE WHEN FABBKTP_RECON_IND |
NO |
REPORTING VIEW |
INVOICE_CHECK |
BANK_RECONCILIATION_IND_DESC |
NA |
NO |
| CASE WHEN FABCHKS_CHECK_TYPE_IND |
NO |
REPORTING VIEW |
INVOICE_CHECK |
CHECK_TYPE_DESC |
NA |
NO |
| CASE WHEN FABCHKS_RECON_IND |
NO |
REPORTING VIEW |
INVOICE_CHECK |
RECONCILIATION_IND_DESC |
NA |
NO |
| CASE WHEN FGBENCD_CMT_TYPE |
NO |
REPORTING VIEW |
AF_ENCUMBRANCE_ACCOUNTING |
COMMITMENT_TYPE_DESC |
NA |
NO |
| CASE WHEN FGBENCD_FIELD_CODE |
NO |
REPORTING VIEW |
ENCUMBRANCE_ACCOUNTING AF_ENCUMBRANCE_ACCOUNTING |
FIELD_CODE_DESC FIELD_CODE_DESC |
NA NA |
NO NO |
| CASE WHEN FTVVEND_CHECK_PIDM IS NULL |
NO |
REPORTING VIEW |
AF_VENDOR AF_VENDOR |
REMIT_TO_ADDRESS_TYPE REMIT_TO_ADDRESS_NUMBER |
NA NA |
NO NO |
| CASE WHEN HR_ENCUMBRANCE_IND |
NO |
REPORTING VIEW |
ENCUMBRANCE_ACCOUNTING ENCUMBRANCE_ACCOUNTING ENCUMBRANCE_ACCOUNTING |
LABOR_ITEM_TYPE HR_ENCUMBRANCE_PERIOD_DESC HR_ENCUMBRANCE_PERIOD |
NA NA NA |
NO NO NO |
| CASE WHEN NORTRAN_AUBK_CODE = 'SPRIDEN' THEN 'IDEN' |
NO |
REPORTING VIEW |
PERSONNEL_ACTION_GENERAL |
PAF_TRANSACTION_TYPE |
NA |
NO |
| CASE WHEN RORSTAT_ADDL_STFD_ELIG_IND |
NO |
REPORTING VIEW |
FINAID_APPLICANT_STATUS |
ADDITIONAL_STAFFORD_AWRDS_DESC |
NA |
NO |
| CASE WHEN RORSTAT_DEP_NO_PAR_DATA |
NO |
REPORTING VIEW |
FINAID_APPLICANT_STATUS |
DEPENDENT_NO_PARENT_DATA_DESC |
NA |
NO |
| CASE WHEN RRRAREQ_SYS_IND |
NO |
REPORTING VIEW |
FINAID_TRACKING_REQUIREMENT |
REQUIREMENT_SOURCE_DESC |
NA |
NO |
| CASE WHEN STAFF_ASSIGNMENT_STATUS_IND |
NO |
REPORTING VIEW |
PROSPECT_STAFF_ASSIGNMENT |
ACTIVE_STAFF_ASSIGNMENT_IND |
NA |
NO |
| CASE WHEN STRATEGY_PLAN_STATUS_IND |
NO |
REPORTING VIEW |
PROSPECT_MOVES_MANAGEMENT CONSTITUENT_CONTACT |
ACTIVE_PROSPECT_STRATEGY_IND ACTIVE_PROSPECT_STRATEGY_IND |
NA NA |
NO NO |
| DECODE(FORCIRR_DATA_ORIGIN) |
NO |
REPORTING VIEW |
AUTHORIZATION_APPROVAL_HISTORY REIMBURSEMENT_APPROVAL_HISTORY |
ADDITIONAL_APPROVER_IND ADDITIONAL_APPROVER_IND |
NA NA |
NO NO |
| DECODE(FPRPODA_NSF_SUSP_IND) |
NO |
REPORTING VIEW |
PURCHASE_ORDER_ITEM_ACCOUNTING |
NSF_SUSPENSE_DESC |
NA |
NO |
| DECODE(FRBEVNG_PMT_METHOD_TYPE_IND) |
NO |
|
|
|
|
|
| DECODE(FRVBFRM_TYPE_IND) |
NO |
REPORTING VIEW |
GRANT_PERSONNEL GRANT_EVENT |
BILL_FORMAT_TYPE_DESC BILL_FORMAT_TYPE_DESC |
NA NA |
NO NO |
| DECODE(RCRAPP2_C_1_ANLY_TYPE) |
NO |
REPORTING VIEW |
NEED_ANALYSIS_FEDERAL_METHOD |
FM_ANALYSIS_TYPE_DESC |
NA |
NO |
| DECODE(RCRAPP2_C_1_CTRB_OFFL_EST) |
NO |
REPORTING VIEW |
NEED_ANALYSIS_FEDERAL_METHOD |
FM_CONTRIBUTION_OFFICIAL_DESC |
NA |
NO |
| DECODE(RCRAPP2_C_MRTL_STATUS) |
NO |
REPORTING VIEW |
NEED_ANALYSIS_FEDERAL_METHOD |
FM_MARITAL_STATUS_DESC |
NA |
NO |
| DECODE(RCRAPP2_C_PAR_1_ANLY_TYPE) |
NO |
REPORTING VIEW |
NEED_ANALYSIS_FEDERAL_METHOD |
FM_PARENT_ANALYSIS_TYPE_DESC |
NA |
NO |
| DECODE(RCRAPP2_C_PAR_MRTL_STATUS) |
NO |
REPORTING VIEW |
NEED_ANALYSIS_FEDERAL_METHOD |
FM_PARENT_MARITAL_STATUS_DESC |
NA |
NO |
| DECODE(RCRAPP2_MODEL_CDE) |
NO |
REPORTING VIEW |
NEED_ANALYSIS NEED_ANALYSIS_DEMOGRAPHIC NEED_ANALYSIS_DEMOGRAPHIC NEED_ANALYSIS NEED_ANALYSIS_FEDERAL_METHOD |
FAMILY_SIZE FAMILY_SIZE FAMILY_IN_COLLEGE FAMILY_IN_COLLEGE FM_FAMILY_SIZE |
NA NA NA NA NA |
NO NO NO NO NO |
| DECODE(RCRAPP2_PELL_ANLY_TYPE) |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
SIMPLIFIED_NEEDS_TEST_IND |
NA |
NO |
| DECODE(RCRAPP2_PELL_PGI_OFFL_EST) |
NO |
REPORTING VIEW |
NEED_ANALYSIS_FEDERAL_METHOD |
PELL_EFC_OFFICIAL_DESC |
NA |
NO |
| DECODE(RCRAPP4_C_NA_1_PELL_OFFL_EST) |
NO |
REPORTING VIEW |
NEED_ANALYSIS_FEDERAL_METHOD |
PELL_EFC_OFFICIAL_EST_DESC |
NA |
NO |
| DECODE(RCRAPP4_C_NA_1_P_CTRB_OFFL_EST) |
NO |
REPORTING VIEW |
NEED_ANALYSIS_FEDERAL_METHOD |
FM_PARENT_CONTRIB_OFF_EST_DESC |
NA |
NO |
| DECODE(RCRAPP4_EFC_CHANGE_IND) |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
EFC_CHANGE_FLAG_DESC |
NA |
NO |
| DECODE(RCRAPP4_NSLDS_MATCH) |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
NATIONAL_STUDENT_LOAN_SYS_DESC |
NA |
NO |
| DECODE(RCRAPP4_SOURCE_CORRECTION) |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
CORRECTION_SOURCE_DESC |
NA |
NO |
| DECODE(SFBETRM_PIDM, NULL, 'N', 'Y') |
NO |
REPORTING VIEW |
VETERAN_CERTIFICATION |
ENROLLMENT_EXISTS_IND |
NA |
NO |
| DECODE(STVAPDC_APPL_INACT) |
NO |
REPORTING VIEW |
GOVERNMENT_ADMISSIONS |
APPLICATION_INACTIVE_IND |
NA |
NO |
| DECODE(STVAPDC_INST_ACC_IND) |
NO |
REPORTING VIEW |
GOVERNMENT_ADMISSIONS |
INSTITUTION_ADMIT_IND |
NA |
NO |
| DECODE(STVAPDC_REJECT_IND) |
NO |
REPORTING VIEW |
GOVERNMENT_ADMISSIONS |
INSTITUTION_DENIED_IND |
NA |
NO |
| DECODE(STVAPDC_SIGNF_IND) |
NO |
REPORTING VIEW |
GOVERNMENT_ADMISSIONS |
APPLICATION_SIGNIF_IND |
NA |
NO |
| DECODE(STVAPDC_STDN_ACC_IND) |
NO |
REPORTING VIEW |
GOVERNMENT_ADMISSIONS |
APPLICANT_ACCEPT_IND |
NA |
NO |
| DECODE(STVSBGI_TYPE_IND,'C','COLLEGE', 'H','HIGHSCHOOL','S','SOURCE-ONLY',NULL) |
NO |
REPORTING VIEW |
FINAID_TRACKING_REQUIREMENT |
INSTITUTION_TYPE_DESC |
NA |
NO |
| DECODE���������.. |
NO |
REPORTING VIEW |
FACULTY_FEEDBACK |
FEEDBACK_STATUS_DESC |
NA |
NO |
| EARN |
NO |
REPORTING VIEW |
PERSONNEL_ACTION_EARNING |
PAF_TRANSACTION_TYPE |
NA |
NO |
| FRVEVNT_DESC || FRBEVNG_ALTERNATE_EVENT_DESC |
NO |
REPORTING VIEW |
GRANT_EVENT |
GRANT_EVENT_FULL_DESC |
NA |
NO |
| FRVEVNT_DESC || FRBEVNG_ALTERNATE_EVNT_DESC |
NO |
REPORTING VIEW |
GRANT_EVENT_STATUS |
GRANT_EVENT_FULL_DESC |
NA |
NO |
| F_GET_NORM_BALANCE |
NO |
REPORTING VIEW |
GRANT_DEFERRED_COST |
ORIG_CALC_TRANSACTION_AMOUNT |
NA |
NO |
| NVL(AMBPLAN_END_DATE,'31-DEC-2099') |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT PROSPECT_MOVES_MANAGEMENT |
STRATEGY_PLAN_END_DATE STRATEGY_PLAN_END_DATE |
NA NA |
NO NO |
| NVL(AMRSTAF_END_DATE,'31-DEC-2099') |
NO |
REPORTING VIEW |
PROSPECT_STAFF_ASSIGNMENT |
STAFF_ASSIGNMENT_END_DATE |
NA |
NO |
| NVL(FARINVA_APPR_AMT,0)+NVL( FARINVA_ADDL_CHRG_AMT,0)+NVL( FARINVA_TAX_AMT,0)-NVL(FARINVA_DISC_AMT, 0) |
NO |
REPORTING VIEW |
INVOICE_ITEM_ACCOUNTING |
APPROVED_CHARGE_AMOUNT |
NA |
NO |
| NVL(FGBENCD_ABAL_OVERRIDE) |
NO |
REPORTING VIEW |
AF_ENCUMBRANCE_ACCOUNTING |
AVAILABLE_BALANCE_OVERRIDE_IND |
NA |
NO |
| NVL(FGBENCH_EDIT_DEFERRAL,'N') |
NO |
REPORTING VIEW |
ENCUMBRANCE |
DEFERRED_EDIT_IND |
NA |
NO |
| NVL(FGBENCH_NSF_ON_OFF_IND,'N') |
NO |
REPORTING VIEW |
ENCUMBRANCE |
NSF_ON_OFF_IND |
NA |
NO |
| NVL(FPRPODA_AMT,0) |
NO |
REPORTING VIEW |
PURCHASE_ORDER_ITEM_ACCOUNTING |
AMOUNT |
NA |
NO |
| NVL(FPRPODA_AMT,0)+NVL( FPRPODA_ADDL_CHRG_AMT,0)+NVL( FPRPODA_TAX_AMT,0)-NVL(FPRPODA_DISC_AMT, 0) |
NO |
REPORTING VIEW |
PURCHASE_ORDER_ITEM_ACCOUNTING |
APPROVED_CHARGE_AMOUNT |
NA |
NO |
| NVL(FPRPODA_CLOSED_IND,'N') |
NO |
REPORTING VIEW |
PURCHASE_ORDER_ITEM_ACCOUNTING |
CLOSED_IND |
NA |
NO |
| NVL(FPRPODA_CONVERT_ADDL_CHRG_AMT,0) |
NO |
REPORTING VIEW |
PURCHASE_ORDER_ITEM_ACCOUNTING |
CONVERTED_ADDITIONAL_AMOUNT |
NA |
NO |
| NVL(FPRPODA_CONVERT_AMT,0) |
NO |
REPORTING VIEW |
PURCHASE_ORDER_ITEM_ACCOUNTING |
CONVERTED_AMOUNT |
NA |
NO |
| NVL(FPRPODA_CONVERT_DISC_AMT,0) |
NO |
REPORTING VIEW |
PURCHASE_ORDER_ITEM_ACCOUNTING |
CONVERTED_DISCOUNT_AMOUNT |
NA |
NO |
| NVL(FPRPODA_CONVERT_TAX_AMT,0) |
NO |
REPORTING VIEW |
PURCHASE_ORDER_ITEM_ACCOUNTING |
CONVERTED_TAX_AMOUNT |
NA |
NO |
| NVL(FPRPODA_DISC_AMT,0) |
NO |
REPORTING VIEW |
PURCHASE_ORDER_ITEM_ACCOUNTING |
DISCOUNT_AMOUNT |
NA |
NO |
| NVL(FPRPODA_ENCB_ADJT_AMT,0) |
NO |
REPORTING VIEW |
PURCHASE_ORDER_ITEM_ACCOUNTING |
ENCUMBRANCE_ADJUSTMENT_AMOUNT |
NA |
NO |
| NVL(FPRPODA_NSF_OVERRIDE_IND,'N') |
NO |
REPORTING VIEW |
PURCHASE_ORDER_ITEM_ACCOUNTING |
NSF_OVERRIDE_IND |
NA |
NO |
| NVL(FPRPODA_SUSP_IND,'N') |
NO |
REPORTING VIEW |
PURCHASE_ORDER_ITEM_ACCOUNTING |
SUSPENSE_IND |
NA |
NO |
| NVL(FPRPODA_TAX_AMT,0) |
NO |
REPORTING VIEW |
PURCHASE_ORDER_ITEM_ACCOUNTING |
TAX_AMOUNT |
NA |
NO |
| NVL(FPRPODT_ADDL_CHRG_AMT,0) |
NO |
REPORTING VIEW |
PURCHASE_ORDER_ITEM_ACCOUNTING |
ADDITIONAL_AMOUNT |
NA |
NO |
| NVL(FTPREXPS.PCARD_ID, FTTVPAYM.PCARD_ID) |
NO |
|
|
|
|
|
| NVL(FTVVEND_TERM_DATE,'31-DEC-2099') |
NO |
REPORTING VIEW |
AF_VENDOR |
VENDOR_TERMINATION_DATE |
NA |
NO |
| NVL(FTVVEND_VEND_CHECK_PIDM, FTVVEND_PIDM) |
NO |
REPORTING VIEW |
VENDOR AF_VENDOR |
REMIT_TO_VENDOR_UID REMIT_TO_VENDOR_UID |
NA NA |
NO NO |
| NVL(RCRAPP4_DUP_SSN_IND) |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
DUPLICATE_TAX_ID_IND |
NA |
NO |
| NVL(RCRAPP4_PUSH_ISIR_FLAG) |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
CPS_ISIR_PUSHED_IND |
NA |
NO |
| NVL(RPRLAPP_DEFERMENT_OPT,'N') |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
DEFERRED_PAYMENT_IND |
NA |
NO |
| NVL(RPRLAPP_MAX_LOAN_IND,'N') |
NO |
REPORTING VIEW |
LOAN_APPLICATION |
MAXIMUM_LOAN_REQUESTED_IND |
NA |
NO |
| NVL(SFRSTCR_APPR_OVER,'N') |
NO |
REPORTING VIEW |
STUDENT_COURSE |
SPECIAL_APPROVAL_OVERRIDE_IND |
NA |
NO |
| NVL(SFRSTCR_ATTS_OVER,'N') |
NO |
REPORTING VIEW |
STUDENT_COURSE |
STUDENT_ATTRIBUTE_OVERRIDE_IND |
NA |
NO |
| NVL(SFRSTCR_CAMP_OVER,'N') |
NO |
REPORTING VIEW |
STUDENT_COURSE |
CAMPUS_RESTRICT_OVERRIDE_IND |
NA |
NO |
| NVL(SFRSTCR_CAPC_OVER,'N') |
NO |
REPORTING VIEW |
STUDENT_COURSE |
CAPACITY_OVERRIDE_IND |
NA |
NO |
| NVL(SFRSTCR_CHRT_OVER,'N') |
NO |
REPORTING VIEW |
STUDENT_COURSE |
STUDENT_COHORT_OVERRIDE_IND |
NA |
NO |
| NVL(SFRSTCR_CLAS_OVER,'N') |
NO |
REPORTING VIEW |
STUDENT_COURSE |
CLASS_RESTRICT_OVERRIDE_IND |
NA |
NO |
| NVL(SFRSTCR_COLL_OVER,'N') |
NO |
REPORTING VIEW |
STUDENT_COURSE |
COLLEGE_RESTRICT_OVERRIDE_IND |
NA |
NO |
| NVL(SFRSTCR_CORQ_OVER,'N') |
NO |
REPORTING VIEW |
STUDENT_COURSE |
COREQUISITE_OVERRIDE_IND |
NA |
NO |
| NVL(SFRSTCR_DEGC_OVER,'N') |
NO |
REPORTING VIEW |
STUDENT_COURSE |
DEGREE_RESTRICT_OVERRIDE_IND |
NA |
NO |
| NVL(SFRSTCR_DEPT_OVER,'N') |
NO |
REPORTING VIEW |
STUDENT_COURSE |
DEPARTMENT_RESTRICT_OVER_IND |
NA |
NO |
| NVL(SFRSTCR_DUPL_OVER,'N') |
NO |
REPORTING VIEW |
STUDENT_COURSE |
DUPLICATE_COURSE_OVERRIDE_IND |
NA |
NO |
| NVL(SFRSTCR_LEVL_OVER,'N') |
NO |
REPORTING VIEW |
STUDENT_COURSE |
LEVEL_RESTRICT_OVERRIDE_IND |
NA |
NO |
| NVL(SFRSTCR_LINK_OVER,'N') |
NO |
REPORTING VIEW |
STUDENT_COURSE |
LINK_OVERRIDE_IND |
NA |
NO |
| NVL(SFRSTCR_MAJR_OVER,'N') |
NO |
REPORTING VIEW |
STUDENT_COURSE |
MAJOR_RESTRICT_OVERRIDE_IND |
NA |
NO |
| NVL(SFRSTCR_MEXC_OVER,'N') |
NO |
REPORTING VIEW |
STUDENT_COURSE |
MUTUTAL_EXCLUSION_OVERRIDE_IND |
NA |
NO |
| NVL(SFRSTCR_PREQ_OVER,'N') |
NO |
REPORTING VIEW |
STUDENT_COURSE |
PREREQUISITE_OVERRIDE_IND |
NA |
NO |
| NVL(SFRSTCR_PROG_OVER,'N') |
NO |
REPORTING VIEW |
STUDENT_COURSE |
PROGRAM_RESTRICT_OVERRIDE_IND |
NA |
NO |
| NVL(SFRSTCR_REPT_OVER,'N') |
NO |
REPORTING VIEW |
STUDENT_COURSE |
REPEAT_COURSE_OVERRIDE_IND |
NA |
NO |
| NVL(SFRSTCR_RPTH_OVER,'N') |
NO |
REPORTING VIEW |
STUDENT_COURSE |
REPEAT_COURSE_CREDIT_OVER_IND |
NA |
NO |
| NVL(SFRSTCR_TEST_OVER,'N') |
NO |
REPORTING VIEW |
STUDENT_COURSE |
TEST_SCORE_OVERRIDE_IND |
NA |
NO |
| NVL(SFRSTCR_TIME_OVER,'N') |
NO |
REPORTING VIEW |
STUDENT_COURSE |
TIME_CONFLICT_OVERRIDE_IND |
NA |
NO |
| SFRSTCR_SUBJ_CODE||SFRSTCR_CRSE_NUMB |
NO |
REPORTING VIEW |
FACULTY_FEEDBACK_DETAIL FACULTY_FEEDBACK |
COURSE_IDENTIFICATION COURSE_IDENTIFICATION |
NA NA |
NO NO |
| SHRTRCE_SUBJ_CODE||SHRTRCE_CRSE_NUMB |
NO |
REPORTING VIEW |
STUDENT_TRANSFERRED_COURSE |
COURSE_IDENTIFICATION |
NA |
NO |
| SHRTRCE_TRIT_SEQ_NO||TO_CHAR( SHRTRCE_TRAM_SEQ_NO,'FM09')||TO_CHAR( NVL(SHRTRCE_TRCR_SEQ_NO,0),'FM009') ||TO_CHAR(SHRTRCE_SEQ_NO,'FM009') |
NO |
REPORTING VIEW |
STUDENT_TRANSFERRED_COURSE |
COURSE_REFERENCE_NUMBER |
NA |
NO |
| SHRTRCR_TRANS_COURSE_NAME||SHRTRCR_TRANS _COURSE_NUMBERS |
NO |
REPORTING VIEW |
STUDENT_TRANSFERRED_COURSE |
TRANSFER_COURSE_IDENTIFICATION |
NA |
NO |
| SIGN(SUM(NVL((SELECT 0 FROM MTVPARM WHERE MTVPARM_INTERNAL_CODE_GROUP = EDW EXTRACT PARAMETERS AND MTVPARM_INTERNAL_CODE = MINORITY_IND AND MTVPARM_INTERNAL_CODE_2 = NON_MINORITY_RACE_CATEGORY AND MTVPARM_EXTERNAL_CODE = RACE_CATEGORY), 1))) |
NO |
DIMENSION TABLE |
WDT_DEMOGRAPHIC |
MINORITY_IND |
ADVISOR |
NO |
| SPRTELE_INTL_ACCESS||SPRTELE_PHONE_AREA| |SPRTELE_PHONE_NUMBER||SPRTELE_PHONE_EXT |
NO |
REPORTING VIEW |
GRANT_PERSONNEL |
PHONE_NUMBER_COMBINED |
NA |
NO |
| TBD |
NO |
|
|
|
|
|
| TBLD |
NO |
|
|
|
|
|
| TO_CHAR (TO_DATE (FAB1099_RPT_YR, 'RR'), 'YYYY') |
NO |
REPORTING VIEW |
VENDOR_TAXABLE_REPORTING |
TAX_YEAR |
NA |
NO |
| TO_CHAR (TO_DATE (FRRGRNH_FSYR_CODE, 'RR'), 'YYYY' |
NO |
REPORTING VIEW |
GRANT_DEFERRED_COST |
FISCAL_YEAR |
NA |
NO |
| TTBTAXN_AMOUNT_3 * -1 |
NO |
REPORTING VIEW |
STUDENT_TAX_NOTIFICATION |
PRIOR_YEAR_CHARGES_ADJUSTED |
NA |
NO |
| TTBTAXN_AMOUNT_5 * -1 |
NO |
REPORTING VIEW |
STUDENT_TAX_NOTIFICATION |
PRIOR_YR_SCHOLARSHIP_GRANT_ADJ |
NA |
NO |