Columns

Constraints

Grants

Statistics

Triggers

Dependencies

Details

Partitions

Indexes


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS
ID NUMBER(10,0) Yes null 1 null
COUSUBIDFP VARCHAR2(10 BYTE) Yes null 2 null
GEOGRAPHIC_COMPONENT VARCHAR2(2 BYTE) Yes null 3 null
CHARITER NUMBER(3,0) Yes null 4 null
SEX VARCHAR2(1 BYTE) Yes null 5 null
EMPLOYED_POPULATION NUMBER(9,0) Yes null 6 null
MANAGEMENT_PROFESSIONAL NUMBER(9,0) Yes null 7 null
MANAGEMENT_BUSINESS_FINANCE NUMBER(9,0) Yes null 8 null
MANAGEMENT_OCCUPATION NUMBER(9,0) Yes null 9 null
MANAGEMENT_TOP_EXECUTIVE NUMBER(9,0) Yes null 10 null
MANAGEMENT_MARKETING_PR_SALE NUMBER(9,0) Yes null 11 null
MANAGEMENT_FINANCIAL NUMBER(9,0) Yes null 12 null
MANAGEMENT_OP_SPECIAL_NOT_FIN NUMBER(9,0) Yes null 13 null
MANAGEMENT_FARM_FARMER NUMBER(9,0) Yes null 14 null
MANAGEMENT_OTHER_NOT_FARM NUMBER(9,0) Yes null 15 null
BUSINESS_FINANCIAL_OPERATIONS NUMBER(9,0) Yes null 16 null
BUSINESS_OPERATION_SPECIALIST NUMBER(9,0) Yes null 17 null
FINANCIAL_OPERATION_SPECIALIST NUMBER(9,0) Yes null 18 null
ACCOUNTANT_AUDITOR NUMBER(9,0) Yes null 19 null
OTHER_FINANCE_SPECIALIST NUMBER(9,0) Yes null 20 null
PROFESSIONAL NUMBER(9,0) Yes null 21 null
COMPUTER_MATHEMATICAL NUMBER(9,0) Yes null 22 null
COMPUTER_SPECIALIST NUMBER(9,0) Yes null 23 null
MATHEMATICAL_SCIENCE NUMBER(9,0) Yes null 24 null
ARCHITECTURE_ENGINEERING NUMBER(9,0) Yes null 25 null
ARCHITECT_SURVEY_CARTOGRAPHER NUMBER(9,0) Yes null 26 null
ENGINEER NUMBER(9,0) Yes null 27 null
DRAFTER_ENGR_MAP_TECHNICIAN NUMBER(9,0) Yes null 28 null
LIFE_PHYSICAL_SOCIAL_SCIENCE NUMBER(9,0) Yes null 29 null
LIFE_PHYSICAL_SCIENTIST NUMBER(9,0) Yes null 30 null
SOCIAL_SCIENTIST_WORKER NUMBER(9,0) Yes null 31 null
LIFE_PHYS_SOC_SCI_TECHICIAN NUMBER(9,0) Yes null 32 null
COMMUNITY_SOCIAL_SERVICE NUMBER(9,0) Yes null 33 null
SOCIAL_SERVICE_SPECIALIST NUMBER(9,0) Yes null 34 null
RELIGIOUS_WORKERS NUMBER(9,0) Yes null 35 null
LEGAL NUMBER(9,0) Yes null 36 null
LAWYER NUMBER(9,0) Yes null 37 null
JUDGES_OTHER_JUDICIAL_WORKER NUMBER(9,0) Yes null 38 null
LEGAL_SUPPORT_WORKER NUMBER(9,0) Yes null 39 null
EDUCATION_TRAINING_LIBRARY NUMBER(9,0) Yes null 40 null
POSTSECONDARY_TEACHER NUMBER(9,0) Yes null 41 null
PRIMARY_SECOND_SPEC_ED_TEACHER NUMBER(9,0) Yes null 42 null
PRE_KG_ELEM_MID_SCHOOL_TEACHER NUMBER(9,0) Yes null 43 null
SECONDARY_SCHOOL_TEACHER NUMBER(9,0) Yes null 44 null
SPECIAL_EDUCATION_TEACHER NUMBER(9,0) Yes null 45 null
LIBRARIAN_CURATOR_ARCHIVIST NUMBER(9,0) Yes null 46 null
OTHER_TEACHER_EDU_LIBRARY NUMBER(9,0) Yes null 47 null
ART_DESIGN_ENTERTAIN_SPT_MEDIA NUMBER(9,0) Yes null 48 null
ART_DESIGN_WORKER NUMBER(9,0) Yes null 49 null
ENTERTAIN_PERFORM_SPORT_WORKER NUMBER(9,0) Yes null 50 null
MEDIA_COMMUNICATION_WORKER NUMBER(9,0) Yes null 51 null
HEALTHCARE_PRACTITIONER_TECHS NUMBER(9,0) Yes null 52 null
DIAGNOSE_TREAT_PRACTICE_TECHS NUMBER(9,0) Yes null 53 null
PHYSICIAN_SURGEON NUMBER(9,0) Yes null 54 null
REGISTERED_NURSE NUMBER(9,0) Yes null 55 null
THERAPIST NUMBER(9,0) Yes null 56 null
OTHER_DIAG_TREAT_PRACTICE_TECH NUMBER(9,0) Yes null 57 null
HEALTH_TECHNOLOGISTS_TECHS NUMBER(9,0) Yes null 58 null
SERVICE NUMBER(9,0) Yes null 59 null
HEALTHCARE_SUPPORT NUMBER(9,0) Yes null 60 null
NURSING_PSYCHIATRIC_HOME_AIDE NUMBER(9,0) Yes null 61 null
OCCUPATION_PHYS_THERAPIST_AIDE NUMBER(9,0) Yes null 62 null
OTHER_HEALTHCARE_SUPPORT NUMBER(9,0) Yes null 63 null
PROTECTIVE_SERVICE NUMBER(9,0) Yes null 64 null
FIRE_FIGHTING_PREVENTION NUMBER(9,0) Yes null 65 null
LAW_ENFORCEMENT NUMBER(9,0) Yes null 66 null
OTHER_PROTECTIVE NUMBER(9,0) Yes null 67 null
FOOD_PREPARATION_SERVING NUMBER(9,0) Yes null 68 null
COOKS_FOOD_PREPARATION NUMBER(9,0) Yes null 69 null
WAITER_WAITRESSE NUMBER(9,0) Yes null 70 null
FOOD_BEVERAGE_SERVE_NOT_WAITER NUMBER(9,0) Yes null 71 null
OTHER_FOOD_PREPARATION_SERVING NUMBER(9,0) Yes null 72 null
BUILDING_GROUND_CLEAN_MAINTAIN NUMBER(9,0) Yes null 73 null
PERSONAL_CARE_SERVICE NUMBER(9,0) Yes null 74 null
PERSONAL_APPEARANCE NUMBER(9,0) Yes null 75 null
TRANSPORT_TOURISM_LODGING NUMBER(9,0) Yes null 76 null
CHILD_CARE NUMBER(9,0) Yes null 77 null
OTHER_PERSONAL_CARE_SERVICE NUMBER(9,0) Yes null 78 null
SALES_OFFICE NUMBER(9,0) Yes null 79 null
SALES NUMBER(9,0) Yes null 80 null
CASHIERS NUMBER(9,0) Yes null 81 null
RETAIL_NOT_CASHIER NUMBER(9,0) Yes null 82 null
SALE_REP_SERVICE_WHOLESALE_MFG NUMBER(9,0) Yes null 83 null
OTHER_SALES NUMBER(9,0) Yes null 84 null
OFFICE_ADMIN_SUPPORT NUMBER(9,0) Yes null 85 null
COMM_EQUIPMENT_OPERATOR NUMBER(9,0) Yes null 86 null
FINANCE_CLERK_NOT_ACCOUNTING NUMBER(9,0) Yes null 87 null
BOOKKEEP_ACCOUNT_AUDIT_CLERK NUMBER(9,0) Yes null 88 null
INFO_RECORD_CLERK NUMBER(9,0) Yes null 89 null
CUSTOMER_SERVICE_REP NUMBER(9,0) Yes null 90 null
MATERIAL_REC_SCHED_DISPAT_DIST NUMBER(9,0) Yes null 91 null
SECRETARIES_ADMIN_ASSISTANTS NUMBER(9,0) Yes null 92 null
OTHER_OFFICE_ADMIN_SUPPORT NUMBER(9,0) Yes null 93 null
FARMING_FISHING_FORESTRY NUMBER(9,0) Yes null 94 null
AGRICULTURAL NUMBER(9,0) Yes null 95 null
FISH_HUNT_FOREST NUMBER(9,0) Yes null 96 null
CONSTRUCT_EXTRACT_MAINTAIN NUMBER(9,0) Yes null 97 null
CONSTRUCT_EXTRACT NUMBER(9,0) Yes null 98 null
CONSTRUCT_EXTRACT_SUPERVISOR NUMBER(9,0) Yes null 99 null
CARPENTER NUMBER(9,0) Yes null 100 null
CONSTRUCTION_LABORER NUMBER(9,0) Yes null 101 null
ELECTRICIAN NUMBER(9,0) Yes null 102 null
PAINTER_PAPERHANGER NUMBER(9,0) Yes null 103 null
PIPING_PLUMBING_STEAMFITTING NUMBER(9,0) Yes null 104 null
CONSTRUCT_TRADE_NOT_PREVIOUS_5 NUMBER(9,0) Yes null 105 null
OTHER_CONSTRUCTION_TRADES NUMBER(9,0) Yes null 106 null
EXTRACTION_WORKERS NUMBER(9,0) Yes null 107 null
INSTALL_MAINTAIN_REPAIR NUMBER(9,0) Yes null 108 null
VEHICLE_MOBILE_EQUIPMENT_TECH NUMBER(9,0) Yes null 109 null
ELECTRICAL_EQUIPMENT_TECH NUMBER(9,0) Yes null 110 null
PRODUCE_TRANSPORT_MATERIAL_MOV NUMBER(9,0) Yes null 111 null
PRODUCTION NUMBER(9,0) Yes null 112 null
ASSEMBLER_FABRICATOR NUMBER(9,0) Yes null 113 null
FOOD_PROCESSING NUMBER(9,0) Yes null 114 null
METAL_PLASTIC NUMBER(9,0) Yes null 115 null
PRINTING NUMBER(9,0) Yes null 116 null
TEXTILE_APPAREL_FURNISHING NUMBER(9,0) Yes null 117 null
WOODWORKER NUMBER(9,0) Yes null 118 null
PLANT_SYSTEM_OPERATOR NUMBER(9,0) Yes null 119 null
OTHER_PRODUCTION_OCCUPATION NUMBER(9,0) Yes null 120 null
TRANSPORTATION_MATERIAL_MOV NUMBER(9,0) Yes null 121 null
TRANSPORT_MAT_MOV_SUPERVISOR NUMBER(9,0) Yes null 122 null
AIRCRAFT_TRAFFIC_CONTROL NUMBER(9,0) Yes null 123 null
RAIL_WATER_TRANSPORT NUMBER(9,0) Yes null 124 null
BUS_DRIVER NUMBER(9,0) Yes null 125 null
DRIVER_SALES_TRUCK_DRIVER NUMBER(9,0) Yes null 126 null
MOTOR_VEHICLE_OP_NOT_BUS_TRUCK NUMBER(9,0) Yes null 127 null
OTHER_TRANSPORT NUMBER(9,0) Yes null 128 null
MATERIAL_MOVING_WORKERS NUMBER(9,0) Yes null 129 null
LABORER_MATERIAL_MOVER_HAND NUMBER(9,0) Yes null 130 null
OTH_MATERIAL_MOVER_NOT_LABORER NUMBER(9,0) Yes null 131 null
CONSTRAINT_NAME CONSTRAINT_TYPE SEARCH_CONDITION R_OWNER R_TABLE_NAME R_CONSTRAINT_NAME DELETE_RULE STATUS DEFERRABLE VALIDATED GENERATED BAD RELY LAST_CHANGE INDEX_OWNER INDEX_NAME INVALID VIEW_RELATED



Columns


PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
NAME VALUE
NUM_ROWS 776098
BLOCKS 33658
AVG_ROW_LEN 325
SAMPLE_SIZE 776098
LAST_ANALYZED 15-DEC-11
LAST_ANALYZED_SINCE 15-DEC-11



Column Statistics


TRIGGER_NAME TRIGGER_TYPE TRIGGER_OWNER TRIGGERING_EVENT STATUS TABLE_NAME




OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE



References


NAME VALUE
CREATED 15-DEC-11
LAST_DDL_TIME 15-DEC-11
OWNER SF4_00
TABLE_NAME CS_EMPLOYMENT_BY_OCCUPATION
TABLESPACE_NAME COUNTY_SUBDIV_00
CLUSTER_NAME null
IOT_NAME null
STATUS VALID
PCT_FREE 0
PCT_USED null
INI_TRANS 1
MAX_TRANS 255
INITIAL_EXTENT 285212672
NEXT_EXTENT 1048576
MIN_EXTENTS 1
MAX_EXTENTS 2147483645
PCT_INCREASE null
FREELISTS null
FREELIST_GROUPS null
LOGGING NO
BACKED_UP N
NUM_ROWS 776098
BLOCKS 33658
EMPTY_BLOCKS 0
AVG_SPACE 0
CHAIN_CNT 0
AVG_ROW_LEN 325
AVG_SPACE_FREELIST_BLOCKS 0
NUM_FREELIST_BLOCKS 0
DEGREE 1
INSTANCES 1
CACHE N
TABLE_LOCK ENABLED
SAMPLE_SIZE 776098
LAST_ANALYZED 15-DEC-11
PARTITIONED NO
IOT_TYPE null
OBJECT_ID_TYPE null
TABLE_TYPE_OWNER null
TABLE_TYPE null
TEMPORARY N
SECONDARY N
NESTED NO
BUFFER_POOL DEFAULT
ROW_MOVEMENT DISABLED
GLOBAL_STATS YES
USER_STATS NO
DURATION null
SKIP_CORRUPT DISABLED
MONITORING YES
CLUSTER_OWNER null
DEPENDENCIES DISABLED
COMPRESSION ENABLED
COMPRESS_FOR BASIC
DROPPED NO
COMMENTS null
PARTITION_NAME LAST_ANALYZED NUM_ROWS BLOCKS SAMPLE_SIZE HIGH_VALUE




INDEX_OWNER INDEX_NAME UNIQUENESS STATUS INDEX_TYPE TEMPORARY PARTITIONED FUNCIDX_STATUS JOIN_INDEX COLUMNS COLUMN_EXPRESSION