Skip to content

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

TABLE: HR.PER_ZA_AREAS_OF_ASSESSMENT

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


Table to store the Areas of assessment per NQF Assessment


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Primary Key: PER_ZA_AREAS_OF_ASSESSMENT_PK
  1. ColumnAREA_OF_ASSESSMENT_ID
Indexes
Index Type Uniqueness Tablespace Column
PER_ZA_AREAS_OF_ASSESSMENT_PK NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnAREA_OF_ASSESSMENT_ID
Columns
Name Datatype Length Mandatory Comments
AREA_OF_ASSESSMENT_ID NUMBER (9) Yes Unique Area of Assessment Identifier
ASSESSMENT_ID NUMBER (9) Yes Assessment Identifier
AREA_OF_ASSESSMENT VARCHAR2 (80) Yes Area of Assessment Description
ASSESSMENT_RESULT VARCHAR2 (120)
Assessment Results - free text
ASSESSMENT_CRITERIA VARCHAR2 (120)
Assessment Criteria - free text
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 AREA_OF_ASSESSMENT_ID
,      ASSESSMENT_ID
,      AREA_OF_ASSESSMENT
,      ASSESSMENT_RESULT
,      ASSESSMENT_CRITERIA
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PER_ZA_AREAS_OF_ASSESSMENT;

Dependencies

[top of page]

HR.PER_ZA_AREAS_OF_ASSESSMENT does not reference any database object

HR.PER_ZA_AREAS_OF_ASSESSMENT is referenced by following:

SchemaHR
ViewPER_ZA_AREAS_OF_ASSESSMENT#