SGHE Banner Operational Data Store
Reporting View Source: CALCULATION - NULL
| Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
| ( TRUNC(SYSDATE) - NVL( CONT_LAST_REC.CONTACT_DATE,TRUNC( SYSDATE)) ); |
NA |
|
|
|
|
| (MAKFUNC.F_ORG_TOTAL_DONOR_COUNT / ORGANIZATION_DONOR_COUNT_GOAL * 100 |
NA |
|
|
|
|
| DECODE(FORCIRR_DATA_ORIGIN) |
NA |
REPORTING VIEW |
REIMBURSEMENT_APPROVAL_HISTORY AUTHORIZATION_APPROVAL_HISTORY |
ADDITIONAL_APPROVER_IND ADDITIONAL_APPROVER_IND |
|
| NVL(FTPREXPS.PCARD_ID, FTTVPAYM.PCARD_ID) |
NA |
|
|
|
|
| NVL(SFRSTCR_APPR_OVER,'N') |
NA |
REPORTING VIEW |
STUDENT_COURSE |
SPECIAL_APPROVAL_OVERRIDE_IND |
|
| NVL(SFRSTCR_ATTS_OVER,'N') |
NA |
REPORTING VIEW |
STUDENT_COURSE |
STUDENT_ATTRIBUTE_OVERRIDE_IND |
|
| NVL(SFRSTCR_CAMP_OVER,'N') |
NA |
REPORTING VIEW |
STUDENT_COURSE |
CAMPUS_RESTRICT_OVERRIDE_IND |
|
| NVL(SFRSTCR_CAPC_OVER,'N') |
NA |
REPORTING VIEW |
STUDENT_COURSE |
CAPACITY_OVERRIDE_IND |
|
| NVL(SFRSTCR_CHRT_OVER,'N') |
NA |
REPORTING VIEW |
STUDENT_COURSE |
STUDENT_COHORT_OVERRIDE_IND |
|
| NVL(SFRSTCR_CLAS_OVER,'N') |
NA |
REPORTING VIEW |
STUDENT_COURSE |
CLASS_RESTRICT_OVERRIDE_IND |
|
| NVL(SFRSTCR_COLL_OVER,'N') |
NA |
REPORTING VIEW |
STUDENT_COURSE |
COLLEGE_RESTRICT_OVERRIDE_IND |
|
| NVL(SFRSTCR_CORQ_OVER,'N') |
NA |
REPORTING VIEW |
STUDENT_COURSE |
COREQUISITE_OVERRIDE_IND |
|
| NVL(SFRSTCR_DEGC_OVER,'N') |
NA |
REPORTING VIEW |
STUDENT_COURSE |
DEGREE_RESTRICT_OVERRIDE_IND |
|
| NVL(SFRSTCR_DEPT_OVER,'N') |
NA |
REPORTING VIEW |
STUDENT_COURSE |
DEPARTMENT_RESTRICT_OVER_IND |
|
| NVL(SFRSTCR_DUPL_OVER,'N') |
NA |
REPORTING VIEW |
STUDENT_COURSE |
DUPLICATE_COURSE_OVERRIDE_IND |
|
| NVL(SFRSTCR_LEVL_OVER,'N') |
NA |
REPORTING VIEW |
STUDENT_COURSE |
LEVEL_RESTRICT_OVERRIDE_IND |
|
| NVL(SFRSTCR_LINK_OVER,'N') |
NA |
REPORTING VIEW |
STUDENT_COURSE |
LINK_OVERRIDE_IND |
|
| NVL(SFRSTCR_MAJR_OVER,'N') |
NA |
REPORTING VIEW |
STUDENT_COURSE |
MAJOR_RESTRICT_OVERRIDE_IND |
|
| NVL(SFRSTCR_MEXC_OVER,'N') |
NA |
REPORTING VIEW |
STUDENT_COURSE |
MUTUTAL_EXCLUSION_OVERRIDE_IND |
|
| NVL(SFRSTCR_PREQ_OVER,'N') |
NA |
REPORTING VIEW |
STUDENT_COURSE |
PREREQUISITE_OVERRIDE_IND |
|
| NVL(SFRSTCR_PROG_OVER,'N') |
NA |
REPORTING VIEW |
STUDENT_COURSE |
PROGRAM_RESTRICT_OVERRIDE_IND |
|
| NVL(SFRSTCR_REPT_OVER,'N') |
NA |
REPORTING VIEW |
STUDENT_COURSE |
REPEAT_COURSE_OVERRIDE_IND |
|
| NVL(SFRSTCR_RPTH_OVER,'N') |
NA |
REPORTING VIEW |
STUDENT_COURSE |
REPEAT_COURSE_CREDIT_OVER_IND |
|
| NVL(SFRSTCR_TEST_OVER,'N') |
NA |
REPORTING VIEW |
STUDENT_COURSE |
TEST_SCORE_OVERRIDE_IND |
|
| NVL(SFRSTCR_TIME_OVER,'N') |
NA |
REPORTING VIEW |
STUDENT_COURSE |
TIME_CONFLICT_OVERRIDE_IND |
|
| 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))) |
NA |
|
|
|
|