[Home] [Help] [Dependency Information]
Object Name: | PER_DISABILITIES_F_DFV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CONTEXT_VALUE | VARCHAR2 | (30) | ||
RELEVANT_TO_SOCIAL_SECURITY | VARCHAR2 | (150) | ||
ID_CARD_NUMBER | VARCHAR2 | (150) | ||
ID_CARD_ISSUE_DATE | DATE | |||
ID_CARD_EXPIRY_DATE | DATE | |||
REDUCED_MOBILITY | VARCHAR2 | (150) | ||
DISABILITY_CLASS | VARCHAR2 | (150) | ||
PREVIOUSLY_PLACED_BY_COTOREP | VARCHAR2 | (150) | ||
BLIND | VARCHAR2 | (150) | ||
PROOF_OF_CERT | VARCHAR2 | (150) | ||
DISABILITY_GRADE | VARCHAR2 | (150) | ||
DISABILITY_EFFECTIVE_DATE | DATE | |||
CERTIFICATE_OF_DISABILITY | VARCHAR2 | (150) | ||
RANGE_OF_DISABILITY | VARCHAR2 | (150) | ||
REPORTING_DESCRIPTION | VARCHAR2 | (150) | ||
RELATED_DISABILITY_ID | VARCHAR2 | (150) | ||
SUBSIDIZED_DAYS | VARCHAR2 | (150) | ||
TYPE_OF_DISABILITY | VARCHAR2 | (150) | ||
CONSEQUENCE | VARCHAR2 | (150) | ||
DISABILITY_CONTROL | VARCHAR2 | (150) | ||
DISABILITY_DEGREE | VARCHAR2 | (150) | ||
WAO_WORK_RESUMPTION | VARCHAR2 | (150) | ||
WAO_REMAINING_HOURS | NUMBER | |||
WAO_REMAINING_HOURS_UNITS | VARCHAR2 | (150) | ||
REA_ADJUSTMENT | VARCHAR2 | (150) | ||
EMPLOYMENT_OFFICE | VARCHAR2 | (150) | ||
CONCATENATED_SEGMENTS | VARCHAR2 | (785) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CONTEXT_VALUE
, RELEVANT_TO_SOCIAL_SECURITY
, ID_CARD_NUMBER
, ID_CARD_ISSUE_DATE
, ID_CARD_EXPIRY_DATE
, REDUCED_MOBILITY
, DISABILITY_CLASS
, PREVIOUSLY_PLACED_BY_COTOREP
, BLIND
, PROOF_OF_CERT
, DISABILITY_GRADE
, DISABILITY_EFFECTIVE_DATE
, CERTIFICATE_OF_DISABILITY
, RANGE_OF_DISABILITY
, REPORTING_DESCRIPTION
, RELATED_DISABILITY_ID
, SUBSIDIZED_DAYS
, TYPE_OF_DISABILITY
, CONSEQUENCE
, DISABILITY_CONTROL
, DISABILITY_DEGREE
, WAO_WORK_RESUMPTION
, WAO_REMAINING_HOURS
, WAO_REMAINING_HOURS_UNITS
, REA_ADJUSTMENT
, EMPLOYMENT_OFFICE
, CONCATENATED_SEGMENTS
FROM APPS.PER_DISABILITIES_F_DFV;
|
|
|