SGHE Banner Operational Data Store
Reporting View Source: CONSTANT - NULL
| Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
| 'A' |
NA |
REPORTING VIEW |
INTEREST |
SOURCE |
|
| 'ADVANCEMENT' |
NA |
REPORTING VIEW |
INTEREST |
SOURCE_DESC |
|
| 'CONSTITUENT_ENTITY_F1B' |
TBD |
|
|
|
|
| 'CONSTITUENT_ENTITY_TYPE_F1B' |
TBD |
|
|
|
|
| 'CONTACT_REPORT_F1B' |
TBD |
|
|
|
|
| 'DESIGNATION_ATTRIBUTE_F1B' |
TBD |
|
|
|
|
| 'ENTITY_D1B' |
TBD |
|
|
|
|
| 'FUNDRAISING_INITIATIVE_D1B' |
TBD |
|
|
|
|
| 'GIFT_DETAIL_D1B' |
TBD |
|
|
|
|
| 'MANAGE_PROSPECT_PIPELINE_A1' |
TBD |
|
|
|
|
| 'MANAGE_PROSPECT_PIPELINE_A_A1' |
TBD |
|
|
|
|
| 'N' |
NA |
|
|
|
|
| 'NO' |
NA |
|
|
|
|
| 'NOT APPLICABLE' |
TBD |
|
|
|
|
| 'NOT AVAILABLE' |
TBD |
|
|
|
|
| 'PROPOSAL_PURPOSE_RESULT_F1B' |
TBD |
|
|
|
|
| 'PROPOSAL_PURPOSE_STAGE_F1B' |
TBD |
|
|
|
|
| 'PROPOSAL_STAGE_F1B' |
TBD |
|
|
|
|
| 'PROSPECT_F1B' |
TBD |
|
|
|
|
| 'PROSPECT_INTEREST_F1B' |
TBD |
|
|
|
|
| 'RELATIONSHIP_F1B' |
TBD |
|
|
|
|
| 'S' |
NA |
REPORTING VIEW |
INTEREST |
SOURCE |
|
| 'STUDENT' |
NA |
REPORTING VIEW |
INTEREST |
SOURCE_DESC |
|
| 'YES' |
TBD |
|
|
|
|
| 0 |
NA |
|
|
|
|
| 00 |
NA |
|
|
|
|
| 01 |
NA |
REPORTING VIEW |
ACCOUNT_HIERARCHY OPERATING_LEDGER |
CTRL_ADOPTED_BUDGET_SEQUENCE CTRL_ADOPTED_BUDGET_SEQUENCE |
|
| 02 |
NA |
REPORTING VIEW |
ACCOUNT_HIERARCHY OPERATING_LEDGER |
CTRL_BUDGET_ADJUST_SEQUENCE CTRL_BUDGET_ADJUST_SEQUENCE |
|
| 03 |
NA |
REPORTING VIEW |
ACCOUNT_HIERARCHY OPERATING_LEDGER |
CTRL_ACTUAL_ACTIVITY_SEQUENCE CTRL_ACTUAL_ACTIVITY_SEQUENCE |
|
| 04 |
NA |
REPORTING VIEW |
OPERATING_LEDGER ACCOUNT_HIERARCHY |
CTRL_ENCUMBRANCE_SEQUENCE CTRL_ENCUMBRANCE_SEQUENCE |
|
| 05 |
NA |
REPORTING VIEW |
OPERATING_LEDGER ACCOUNT_HIERARCHY |
CTRL_BUDGET_RESERVE_SEQUENCE CTRL_BUDGET_RESERVE_SEQUENCE |
|
| 07 |
NA |
REPORTING VIEW |
OPERATING_LEDGER ACCOUNT_HIERARCHY |
CTRL_TEMPORARY_BUDGET_SEQUENCE CTRL_TEMPORARY_BUDGET_SEQUENCE |
|
| 1 |
TBD |
|
|
|
|
| 13 |
NA |
|
|
|
|
| 14 |
NA |
|
|
|
|
| 85 |
NA |
|
|
|
|
| 86 |
NA |
|
|
|
|
| HARDCODED DESCRIPTIONS. |
NA |
REPORTING VIEW |
PORTFOLIO |
AUTHORIZATION_STATUS_DESC |
|
| LAST_PROSP_INT_ASK_DATE_EXPRESSION |
TBD |
|
|
|
TO_DATE('31-DEC-2099','DD-MON-YYYY') |
| NO |
NA |
|
|
|
|
| NULL |
NA |
|
|
|
|
| PROPOSAL_PURP_STAGE_END_DATE_EXPRESSION |
TBD |
|
|
|
to_date('31-DEC-2099','DD-MON-YYYY') |
| PROPOSAL_STAGE_END_DATE_EXPRESSION |
TBD |
|
|
|
to_date('31-DEC-2099','DD-MON-YYYY') |
| PROSPECT_INTEREST_END_DATE_EXPRESSION |
TBD |
|
|
|
TO_DATE('31-DEC-2099','DD-MON-YYYY') |
| PROSPECT_INTEREST_START_DATE_EXPRESSION |
TBD |
|
|
|
TO_DATE('31-DEC-2099','DD-MON-YYYY') |
| PROSPECT_INTEREST_STATUS_DATE_EXPRESSION |
TBD |
|
|
|
TO_DATE('31-DEC-2099','DD-MON-YYYY') |
| PROSPECT_INTEREST_TARGET_DATE_EXPRESSION |
TBD |
|
|
|
TO_DATE('31-DEC-2099','DD-MON-YYYY') |
| PROSPECT_RESULT_DATE_EXPRESSION |
TBD |
|
|
|
TRUNC(TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| PROSPECT_START_DATE_EXPRESSION |
TBD |
|
|
|
TRUNC(TO_DATE('31-DEC-2099','DD-MON-YYYY')) |
| PROSPECT_STOP_DATE_EXPRESSION |
TBD |
|
|
|
TRUNC(TO_DATE('31-DEC-2099','DD-MON-YYYY')) |