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

VIEW: APPS.IGSBV_AD_ACT_PROFILES_SPS

Object Details
Object Name: IGSBV_AD_ACT_PROFILES_SPS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGSBV_AD_ACT_PROFILES_SPS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


ACT profile components and category details for type as SPS Questionnaire


[View Source]

Columns
Name Datatype Length Mandatory Comments
PERSON_IDENTIFIER NUMBER (15)
Person Identifier
REPORTING_YEAR VARCHAR2 (2) Yes Reporting Year
ACT_IDENTIFIER VARCHAR2 (9) Yes ACT Identifier
TEST_TYPE VARCHAR2 (1) Yes Test Type
TEST_DATE_TXT VARCHAR2 (6) Yes Test Date
PROFILE_CATEGORY_CODE VARCHAR2 (10) Yes Profile Category code
_LA:PROFILE_CATEGORY CHAR (73)
_LA:PROFILE_CATEGORY_DESC CHAR (77)
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
Query Text

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


SELECT PERSON_IDENTIFIER
,      REPORTING_YEAR
,      ACT_IDENTIFIER
,      TEST_TYPE
,      TEST_DATE_TXT
,      PROFILE_CATEGORY_CODE
,      _LA:PROFILE_CATEGORY
,      _LA:PROFILE_CATEGORY_DESC
,      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
FROM APPS.IGSBV_AD_ACT_PROFILES_SPS;

Dependencies

[top of page]

APPS.IGSBV_AD_ACT_PROFILES_SPS references the following:

SchemaAPPS
SynonymIGS_AD_ACT_PROFILES
SynonymIGS_PE_ALT_PERS_ID

APPS.IGSBV_AD_ACT_PROFILES_SPS is not referenced by any database object