[Home] [Help] [Dependency Information]
Object Name: | IGSBV_ORG_EXTENSIONS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSBV_ORG_EXTENSIONS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Obsolete
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ORG_CODE | VARCHAR2 | (30) | Yes | The Institution or Organizational Unit Code |
INST_ORG_INDICATOR | VARCHAR2 | (1) | Flag indicates whether it is an organization or institution. 'O' - Organization, 'I' - Institution | |
INSTITUTION_CODE | VARCHAR2 | (30) | Identifier code of the institution in which the Organizational Unit is associated. | |
ORG_START_DATE | DATE | Start date of the org unit | ||
ORG_END_DATE | DATE | End date of the org unit | ||
_LA:ORG_MEMBER_TYPE | CHAR | (63) | Member Type of Organizational Unit | |
ORG_STATUS | VARCHAR2 | (10) | Status of Organizational Unit | |
_LA:ORG_TYPE | CHAR | (57) | Type of Organizational Unit | |
LOCAL_INSTITUTION_INDICATOR | VARCHAR2 | (1) | Flag indicates whether institution is local. | |
OVERSEAS_INDICATOR | VARCHAR2 | (1) | Indicator to show whether the institution is overseas. | |
_LA:GOVT_INSTITUTION_CODE | CHAR | (72) | Government institution code | |
_LA:INST_CONTROL_TYPE | CHAR | (71) | Control Type of Institution. | |
_LA:INST_PRIORITY | CHAR | (70) | Institution Priority | |
INSTITUTION_TYPE | VARCHAR2 | (20) | Type of Institution. | |
INSTITUTION_STATUS | VARCHAR2 | (10) | Status of Institution. | |
INST_MARKET_CODE | VARCHAR2 | (8) | Market code indicator for an institution. | |
INST_PHONE_COUNTRY_CODE | VARCHAR2 | (10) | Country code telephone number for the institution. | |
INST_PHONE_AREA_CODE | VARCHAR2 | (10) | Area Code telephone number for the institution. | |
INST_PHONE_NUMBER | VARCHAR2 | (40) | Telephone number for the institution. | |
ADV_STUDIES_CLASSES | NUMBER | The number of Advanced Studies Classes Offered | ||
HONORS_CLASSES | NUMBER | The number of Honours classes offered | ||
CLASS_SIZE | NUMBER | Size of the class | ||
PERCENT_PLAN_HIGHER_EDU | NUMBER | The percentage of students planning to pursue higher education | ||
PARTY_ID | NUMBER | (15) | Yes | Unique identifier of the party |
SEC_SCHOOL_LOCATION_ID | NUMBER | (15) | Secondary school location identifier | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ORG_CODE
, INST_ORG_INDICATOR
, INSTITUTION_CODE
, ORG_START_DATE
, ORG_END_DATE
, _LA:ORG_MEMBER_TYPE
, ORG_STATUS
, _LA:ORG_TYPE
, LOCAL_INSTITUTION_INDICATOR
, OVERSEAS_INDICATOR
, _LA:GOVT_INSTITUTION_CODE
, _LA:INST_CONTROL_TYPE
, _LA:INST_PRIORITY
, INSTITUTION_TYPE
, INSTITUTION_STATUS
, INST_MARKET_CODE
, INST_PHONE_COUNTRY_CODE
, INST_PHONE_AREA_CODE
, INST_PHONE_NUMBER
, ADV_STUDIES_CLASSES
, HONORS_CLASSES
, CLASS_SIZE
, PERCENT_PLAN_HIGHER_EDU
, PARTY_ID
, SEC_SCHOOL_LOCATION_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSBV_ORG_EXTENSIONS;
APPS.IGSBV_ORG_EXTENSIONS is not referenced by any database object
|
|
|