[Home] [Help] [Dependency Information]
Object Name: | IGS_UC_MV_CVR_P2KPC |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_UC_MV_CVR_P2KPC |
Subobject Name: | |
Status: | VALID |
Holds list of Pre-2000 Parental Occupation Codes and Social Class with description. - OBSOLETE
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
POCC | NUMBER | (3) | Yes | Occupational group (in the range 000 to 999) |
SOCIALCLASS | NUMBER | (1) | Pre-2000 Social Class | |
OCCUPATIONTEXT | VARCHAR2 | (110) | Occupation Text | |
ALTERNATIVETEXT | VARCHAR2 | (40) | Alternative Text | |
ALTERNATECLASS1 | NUMBER | (1) | First Alternative Class | |
ALTERNATECLASS2 | NUMBER | (1) | Second Alternative Class |
Cut, paste (and edit) the following text to query this object:
SELECT POCC
, SOCIALCLASS
, OCCUPATIONTEXT
, ALTERNATIVETEXT
, ALTERNATECLASS1
, ALTERNATECLASS2
FROM IGS.IGS_UC_MV_CVR_P2KPC;
IGS.IGS_UC_MV_CVR_P2KPC does not reference any database object
IGS.IGS_UC_MV_CVR_P2KPC is referenced by following:
|
|
|