[Home] [Help] [Dependency Information]
Object Name: | IGS_UC_CVREFPRE2000POCC_2003 |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_UC_CVREFPRE2000POCC_2003 |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
POCC | NUMBER | (22) | Occupational group (in the range 0000 to 9999) | |
SOCIALCLASS | NUMBER | (22) | Pre-2000 Social Class. 0 - not known1 - professional, 2 - managerial or technical, 3 - skilled - non manual, 4 - skilled - manual, 5 - partly skilled, 6 - unskilled | |
OCCUPATIONTEXT | VARCHAR2 | (110) | Occupation Text | |
ALTERNATIVETEXT | VARCHAR2 | (40) | Alternative Text | |
ALTERNATECLASS1 | NUMBER | (22) | Alternative Class | |
ALTERNATECLASS2 | NUMBER | (22) | Alternative Class |
Cut, paste (and edit) the following text to query this object:
SELECT POCC
, SOCIALCLASS
, OCCUPATIONTEXT
, ALTERNATIVETEXT
, ALTERNATECLASS1
, ALTERNATECLASS2
FROM APPS.IGS_UC_CVREFPRE2000POCC_2003;
|
|
|