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

TABLE: IGS.IGS_AD_ACT_PROFILES

Object Details
Object Name: IGS_AD_ACT_PROFILES
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_AD_ACT_PROFILES
Subobject Name:
Status: VALID


ACT profile components with profile type and corresponding category details


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_AD_ACT_PRFL_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREPORTING_YEAR
ColumnACT_IDENTIFIER
ColumnTEST_TYPE
ColumnTEST_DATE_TXT
ColumnPROFILE_TYPE
ColumnPROFILE_CATEGORY
Columns
Name Datatype Length Mandatory Comments
REPORTING_YEAR VARCHAR2 (2) Yes Reporting Year
ACT_IDENTIFIER VARCHAR2 (9) Yes ACT ID
TEST_TYPE VARCHAR2 (1) Yes Test Type
TEST_DATE_TXT VARCHAR2 (6) Yes Test Date
PROFILE_TYPE VARCHAR2 (10) Yes Profile Type
PROFILE_CATEGORY VARCHAR2 (10) Yes Profile Category
CODE1 VARCHAR2 (1)
Code 1
CODE2 VARCHAR2 (1)
Code 2
CODE3 VARCHAR2 (1)
Code 3
CODE4 VARCHAR2 (1)
Code 4
CODE5 VARCHAR2 (1)
Code 5
CODE6 VARCHAR2 (1)
Code 6
CODE7 VARCHAR2 (1)
Code 7
CODE8 VARCHAR2 (1)
Code 8
CODE9 VARCHAR2 (1)
Code 9
CODE10 VARCHAR2 (1)
Code 10
CODE11 VARCHAR2 (1)
Code 11
CODE12 VARCHAR2 (1)
Code 12
CODE13 VARCHAR2 (1)
Code 13
CODE14 VARCHAR2 (1)
Code 14
CODE15 VARCHAR2 (1)
Code 15
CODE16 VARCHAR2 (1)
Code 16
CODE17 VARCHAR2 (1)
Code 17
CODE18 VARCHAR2 (1)
Code 18
CODE19 VARCHAR2 (1)
Code 19
CODE20 VARCHAR2 (1)
Code 20
CODE21 VARCHAR2 (1)
Code 21
EDUC_MAJOR VARCHAR2 (3)
Education Major
VOC_CHOICE1 VARCHAR2 (3)
Vocabulary Choice 1
VOC_CHOICE2 VARCHAR2 (3)
Vocabulary Choice 2
CHOICE1 VARCHAR2 (2)
Choice 1
CHOICE2 VARCHAR2 (2)
Choice 2
CHOICE3 VARCHAR2 (2)
Choice 3
CHOICE4 VARCHAR2 (2)
Choice 4
CHOICE5 VARCHAR2 (2)
Choice 5
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
Query Text

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


SELECT REPORTING_YEAR
,      ACT_IDENTIFIER
,      TEST_TYPE
,      TEST_DATE_TXT
,      PROFILE_TYPE
,      PROFILE_CATEGORY
,      CODE1
,      CODE2
,      CODE3
,      CODE4
,      CODE5
,      CODE6
,      CODE7
,      CODE8
,      CODE9
,      CODE10
,      CODE11
,      CODE12
,      CODE13
,      CODE14
,      CODE15
,      CODE16
,      CODE17
,      CODE18
,      CODE19
,      CODE20
,      CODE21
,      EDUC_MAJOR
,      VOC_CHOICE1
,      VOC_CHOICE2
,      CHOICE1
,      CHOICE2
,      CHOICE3
,      CHOICE4
,      CHOICE5
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_AD_ACT_PROFILES;

Dependencies

[top of page]

IGS.IGS_AD_ACT_PROFILES does not reference any database object

IGS.IGS_AD_ACT_PROFILES is referenced by following:

SchemaAPPS
SynonymIGS_AD_ACT_PROFILES