[Home] [Help] [Dependency Information]
Object Name: | IGS_OR_UNIT_HIST_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_OR_UNIT_HIST_ALL |
Subobject Name: | |
Status: | VALID |
IGS_OR_UNIT_HIST_ALL describes the history of changes to an organizational unit
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_OR_UNIT_HIST_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ORG_UNIT_CD
OU_START_DT HIST_START_DT |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORG_UNIT_CD | VARCHAR2 | (30) | Yes | The code for the organizational unit. An organizational unit is uniquely identified by the combination of its code and start date. An organizational unit is a business unit of an institution or organization. |
OU_START_DT | DATE | Yes | The date from which the organizational unit is effective. The organizational unit is uniquely identified by the combination of its code and start date. | |
HIST_START_DT | DATE | Yes | The effective start date and time of the organizational unit history record. It is the date and time the previous history record was ended. | |
HIST_END_DT | DATE | Yes | The effective end date and time of the organizational unit history record. | |
HIST_WHO | NUMBER | (15) | Yes | The Oracle username of the person who created the history record |
OU_END_DT | DATE | The end date value for the organizational unit during the creation of the history record. | ||
DESCRIPTION | VARCHAR2 | (360) | Describes the organizational unit during the creation of the history record. | |
ORG_STATUS | VARCHAR2 | (10) | The status of the organizational unit during the creation of the history record. | |
ORG_TYPE | VARCHAR2 | (30) | The organizational type of the organizational unit during the creation of the history record. | |
MEMBER_TYPE | VARCHAR2 | (30) | The member type of the organizational unit during the creation of the history record. | |
INSTITUTION_CD | VARCHAR2 | (30) | The code for the institution the organizational unit was associated with during the creation of the history record. | |
NAME | VARCHAR2 | (360) | The description, or name of the institution the organizational unit was associated with. | |
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 | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
ORG_ID | NUMBER | (15) | An organization ID |
Cut, paste (and edit) the following text to query this object:
SELECT ORG_UNIT_CD
, OU_START_DT
, HIST_START_DT
, HIST_END_DT
, HIST_WHO
, OU_END_DT
, DESCRIPTION
, ORG_STATUS
, ORG_TYPE
, MEMBER_TYPE
, INSTITUTION_CD
, NAME
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
FROM IGS.IGS_OR_UNIT_HIST_ALL;
IGS.IGS_OR_UNIT_HIST_ALL does not reference any database object
IGS.IGS_OR_UNIT_HIST_ALL is referenced by following:
|
|
|