[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_OR_UNIT_FUNDSRC_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_OR_UNIT_FUNDSRC_V
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TCA_PARTY_NUMBER | VARCHAR2 | (30) | Yes | Party Number of the Organization in HZ_PARTIES |
| ORG_UNIT_CD | VARCHAR2 | (30) | The code for the organisational unit. An organisational unit is uniquely identified by the combination of its code and start date. An organisational unit is a business unit of an institution or organisation. Common organisational units in tertiary institutions are faculties, schools, departments and divisions. Each organisational unit must be assigned a start date, description, status, organisational type and member type. An institution code may be assigned to an organisational unit. | |
| START_DT | DATE | The date from which the organisational unit is effective. The organisational unit is uniquely identified by the combination of its code and start date. | ||
| END_DT | DATE | The date from which the organisational unit is no longer effective. | ||
| OU_DESCRIPTION | VARCHAR2 | (360) | Yes | The description of an organisational unit. An organisational unit is a business unit of an institution or organisation. Common organisational units in tertiary institutions are faculties, schools, departments and divisions. Each organisational unit must be assigned a start date, description, status, organisational type and member type. An institution code may be assigned to an organisational unit. |
| ORG_STATUS | VARCHAR2 | (10) | The name of the organisational status assigned to the organisational unit. An organisational unit status indicates the level of activity of an organisational unit record. Each organisational unit must be assigned a status. Examples are ACTIVE and INACTIVE. | |
| ORG_TYPE | VARCHAR2 | (30) | The name of the organisational type assigned to the organisational unit. Organisational types are business category classifications of organisational units. Each organisational unit must be assigned an organisational type. Examples are ACADEMIC and ADMINISTRATIVE. | |
| MEMBER_TYPE | VARCHAR2 | (30) | The name of the member type assigned to the organisational unit. A member type is a classification of organisational units by structure level. Each organisational unit must be assigned a member type. Examples are FACULTY, SCHOOL, DEPARTMENT, and DIVISION. | |
| INSTITUTION_CD | VARCHAR2 | (30) | The code for the institution with which the organisational unit is associated. The association of an organisational unit with an institution is optional. | |
| FUNDING_SOURCE | VARCHAR2 | (10) | Yes | A unique identifier for the institution-defined funding source. This must be mapped to a Government funding source. |
| FS_DESCRIPTION | VARCHAR2 | (60) | Yes | Description of an institution-defined funding source. |
| GOVT_FUNDING_SOURCE | NUMBER | (2) | Yes | The unique identifier for the Government funding source. |
| CLOSED_IND | VARCHAR2 | (1) | Yes | |
| CREATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT TCA_PARTY_NUMBER
, ORG_UNIT_CD
, START_DT
, END_DT
, OU_DESCRIPTION
, ORG_STATUS
, ORG_TYPE
, MEMBER_TYPE
, INSTITUTION_CD
, FUNDING_SOURCE
, FS_DESCRIPTION
, GOVT_FUNDING_SOURCE
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.IGS_OR_UNIT_FUNDSRC_V;
APPS
HZ_PARTIES
IGS_FI_FUND_SRC
IGS_PE_HZ_PARTIES
APPS.IGS_OR_UNIT_FUNDSRC_V is not referenced by any database object
|
|
|
|