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


TABLE: HR.PER_ZA_FORMAL_QUALIFICATIONS

Object Details
Object Name: PER_ZA_FORMAL_QUALIFICATIONS
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.PER_ZA_FORMAL_QUALIFICATIONS
Subobject Name:
Status: VALID


Table to store additional NQF Qualification info for a person


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Primary Key: PER_ZA_FORMAL_QUALS_PK
  1. ColumnQUALIFICATION_ID
Indexes
Index Type Uniqueness Tablespace Column
PER_ZA_FORMAL_QUALS_PK NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnQUALIFICATION_ID
Columns
Name Datatype Length Mandatory Comments
QUALIFICATION_ID NUMBER (9) Yes Unique Qualification Identifier
LEVEL_ID NUMBER (9)
Level Identifier
FIELD_OF_LEARNING VARCHAR2 (30)
Field of learning - free text
SUB_FIELD VARCHAR2 (120)
Sub field of learning - free text
REGISTRATION_DATE DATE

Registration date
REGISTRATION_NUMBER VARCHAR2 (10)
Registration number
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
Query Text

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


SELECT QUALIFICATION_ID
,      LEVEL_ID
,      FIELD_OF_LEARNING
,      SUB_FIELD
,      REGISTRATION_DATE
,      REGISTRATION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PER_ZA_FORMAL_QUALIFICATIONS;

Dependencies

[top of page]

HR.PER_ZA_FORMAL_QUALIFICATIONS does not reference any database object

HR.PER_ZA_FORMAL_QUALIFICATIONS is referenced by following:

SchemaAPPS
SynonymPER_ZA_FORMAL_QUALIFICATIONS
TriggerPER_ZA_FORMAL_QUALIFICATIO_WHO
SchemaPUBLIC
SynonymPER_ZA_FORMAL_QUALIFICATIONS