SGHE Banner Operational Data Store
Composite View Source: CONSTANT - NULL
| Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
| 'A' |
NA |
COMPOSITE VIEW |
AA_INTEREST |
SOURCE |
|
| 'ADVANCEMENT' |
NA |
COMPOSITE VIEW |
AA_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 |
COMPOSITE VIEW |
AS_INTEREST |
SOURCE |
|
| 'STUDENT' |
NA |
COMPOSITE VIEW |
AS_INTEREST |
SOURCE_DESC |
|
| 'YES' |
TBD |
|
|
|
|
| 0 |
NA |
|
|
|
|
| 00 |
NA |
COMPOSITE VIEW |
AF_FISCAL_PERIOD |
FISCAL_PERIOD |
|
| 01 |
NA |
COMPOSITE VIEW |
AF_ACCOUNT_HIERARCHY |
CTRL_ADOPTED_BUDGET_SEQUENCE |
|
| 02 |
NA |
COMPOSITE VIEW |
AF_ACCOUNT_HIERARCHY |
CTRL_BUDGET_ADJUST_SEQUENCE |
|
| 03 |
NA |
COMPOSITE VIEW |
AF_ACCOUNT_HIERARCHY |
CTRL_ACTUAL_ACTIVITY_SEQUENCE |
|
| 04 |
NA |
COMPOSITE VIEW |
AF_ACCOUNT_HIERARCHY |
CTRL_ENCUMBRANCE_SEQUENCE |
|
| 05 |
NA |
COMPOSITE VIEW |
AF_ACCOUNT_HIERARCHY |
CTRL_BUDGET_RESERVE_SEQUENCE |
|
| 07 |
NA |
COMPOSITE VIEW |
AF_ACCOUNT_HIERARCHY |
CTRL_TEMPORARY_BUDGET_SEQUENCE |
|
| 1 |
TBD |
|
|
|
|
| 13 |
NA |
COMPOSITE VIEW |
AF_FISCAL_PERIOD |
FISCAL_PERIOD |
|
| 14 |
NA |
COMPOSITE VIEW |
AF_FISCAL_PERIOD |
FISCAL_PERIOD |
|
| 85 |
NA |
COMPOSITE VIEW |
AE_APPROVAL_HISTORY |
DOC_TYPE |
|
| 86 |
NA |
COMPOSITE VIEW |
AE_APPROVAL_HISTORY |
DOC_TYPE |
|
| HARDCODED DESCRIPTIONS. |
NA |
|
|
|
|
| LAST_PROSP_INT_ASK_DATE_EXPRESSION |
TBD |
|
|
|
TO_DATE('31-DEC-2099','DD-MON-YYYY') |
| NO |
NA |
|
|
|
|
| NULL |
NA |
COMPOSITE VIEW |
AS_INTEREST AS_INTEREST AS_INTEREST AS_INTEREST |
INTEREST_USER_ID INTEREST_USER_ID INTEREST_USER_ID INTEREST_USER_ID |
|
| 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')) |