[Home] [Help] [Dependency Information]
Object Name: | HZ_CERTIFICATIONS |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.HZ_CERTIFICATIONS |
Subobject Name: | |
Status: | VALID |
The HZ_CERTIFICATIONS table stores information about accreditation that is awarded to a party usually following the evaluation of the party by the awarding organization. For example, the International Organization for Standardization has established standards for quality systems. An ISO9000 certification is awarded after an evaluation of an organization that demonstrates adherence to the standards specified by the ISO.
.
The primary key for this table is CERTIFICATION_ID.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HZ_CERTIFICATIONS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CERTIFICATION_ID |
HZ_CERTIFICATIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PARTY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CERTIFICATION_ID | NUMBER | (15) | Yes | Certification identifier |
CERTIFICATION_NAME | VARCHAR2 | (240) | Yes | The name of the certification such as ISO9000 and GMP001. |
CURRENT_STATUS | VARCHAR2 | (30) | Name for the status of the certification. For example, applied for, granted, or expired. | |
PARTY_ID | NUMBER | (15) | Yes | Unique identifier for a party. Foreign key to the HZ_PARTIES table |
EXPIRES_ON_DATE | DATE | Date when certification expires. | ||
GRADE | VARCHAR2 | (30) | Level or grade of certification provided by the ISSUED_BY_AUTHORITY. For example, founding member, gold, fully certified, partially certified. | |
ISSUED_BY_AUTHORITY | VARCHAR2 | (60) | The name of the certifying authority. | |
ISSUED_ON_DATE | DATE | Date when a certification was issued. | ||
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |
PROGRAM_ID | NUMBER | (15) | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
WH_UPDATE_DATE | DATE | Date when the record was entered or changed in a data warehouse | ||
STATUS | VARCHAR2 | (1) | Record status flag |
Cut, paste (and edit) the following text to query this object:
SELECT CERTIFICATION_ID
, CERTIFICATION_NAME
, CURRENT_STATUS
, PARTY_ID
, EXPIRES_ON_DATE
, GRADE
, ISSUED_BY_AUTHORITY
, ISSUED_ON_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, WH_UPDATE_DATE
, STATUS
FROM AR.HZ_CERTIFICATIONS;
AR.HZ_CERTIFICATIONS does not reference any database object
AR.HZ_CERTIFICATIONS is referenced by following:
|
|
|