DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IGSBV_ST_PROG_ATT_COST_CENTRES

Object Details
Object Name: IGSBV_ST_PROG_ATT_COST_CENTRES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGSBV_ST_PROG_ATT_COST_CENTRES
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Base business view to allow queries on Student Program Attempt Cost Center HESA details.


[View Source]

Columns
Name Datatype Length Mandatory Comments
HESA_SPA_CC_ID NUMBER
Yes Sequence number uniquely identifying the HESA student program attempt cost center records
PERSON_ID NUMBER (15) Yes Unique person identifier
PERSON_NUMBER VARCHAR2 (30) Yes Unique person number
PROGRAM_CODE VARCHAR2 (6) Yes Unique identifier for program of study student enrolled on
SPA_COST_CENTRE VARCHAR2 (30) Yes Academic cost centre in which unit taught
SPA_SUBJ VARCHAR2 (10) Yes Unit Subject of area of study
SPA_COST_CENTRE_SUBJ_PROP NUMBER (5) Yes Proportion of teaching allocated to cost centre/subject split
CREATED_BY NUMBER (15) Yes Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO column
LAST_UPDATE_DATE DATE
Yes Standard WHO column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT HESA_SPA_CC_ID
,      PERSON_ID
,      PERSON_NUMBER
,      PROGRAM_CODE
,      SPA_COST_CENTRE
,      SPA_SUBJ
,      SPA_COST_CENTRE_SUBJ_PROP
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_ST_PROG_ATT_COST_CENTRES;

Dependencies

[top of page]

APPS.IGSBV_ST_PROG_ATT_COST_CENTRES references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymIGS_HE_ST_SPA_CC

APPS.IGSBV_ST_PROG_ATT_COST_CENTRES is not referenced by any database object