[Home] [Help] [Dependency Information]
Object Name: | PER_NL_WAO_LIST_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PER.PER_NL_WAO_LIST_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Dutch WAO List shows the details of all employees registered with WAO
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EMPLOYEE_NAME | VARCHAR2 | (240) | Concatenation of last name, title, first name, middle names and the name the person is known by. | |
EMPLOYEE_NUMBER | VARCHAR2 | (30) | Number assigned to a person if they have been an employee. | |
EMPLOYEE_SOFI_NUMBER | VARCHAR2 | (30) | Number by which a person is identified in a given legislation. | |
PERSON_ID | NUMBER | (10) | Yes | System generated person primary key from PER_PEOPLE_S. |
DISABILITY_ID | NUMBER | (10) | Yes | Primary key. Generated from sequence PER_DISABILITIES_S. |
EFFECTIVE_START_DATE | DATE | Yes | Effective Start Date | |
EFFECTIVE_END_DATE | DATE | Yes | Effective End Date | |
FTE | NUMBER | (5) | Yes | Full time equivalence quota. |
DISABILITY_REASON | VARCHAR2 | (30) | Reason for disability. | |
STATUS | VARCHAR2 | (30) | Status of the record | |
CASUAL_INCIDENT | VARCHAR2 | (30) | Yes | Unique reference code for the work incident. |
INCIDENT_DATE | DATE | Yes | Date of incident. | |
REGISTRATION_ID | VARCHAR2 | (30) | ID given to person following registration with disability organization. | |
REGISTRATION_ORGANIZATION | VARCHAR2 | (240) | Yes | Name of the organization. |
REGISTRATION_DATE | DATE | Date of registration with organization for the disabled. | ||
REGISTRATION_EXPIRY_DATE | DATE | Expiry date of registration with organization for the disabled. | ||
DESCRIPTION | VARCHAR2 | (2000) | Description of disability. | |
WORK_RESTRICTION | VARCHAR2 | (2000) | Description of restriction(s) to work. | |
DIABILITY_DEGREE | VARCHAR2 | (150) | Developer descriptive flex column. | |
WORK_RESUMPTION | VARCHAR2 | (150) | Developer descriptive flex column. | |
REMAINING_HOURS | VARCHAR2 | (150) | Developer descriptive flex column. | |
REMAINING_HOURS_UNITS | VARCHAR2 | (150) | Developer descriptive flex column. | |
LAST_UPDATE_DATE | DATE | standard Who column. | ||
LAST_UPDATED_BY | NUMBER | (15) | standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | standard Who column. | |
CREATED_BY | NUMBER | (15) | standard Who column. | |
CREATION_DATE | DATE | standard Who column. | ||
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flex column. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flex column. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flex column. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flex column. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flex column. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flex column. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flex column. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flex column. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flex column. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flex column. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flex column. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flex column. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flex column. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flex column. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flex column. | |
ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flex column. | |
ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flex column. | |
ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flex column. | |
ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flex column. | |
ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flex column. | |
ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive flex column. | |
ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive flex column. | |
ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive flex column. | |
ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive flex column. | |
ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive flex column. | |
ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive flex column. | |
ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive flex column. | |
ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive flex column. | |
ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive flex column. | |
ATTRIBUTE30 | VARCHAR2 | (150) | Descriptive flex column. |
Cut, paste (and edit) the following text to query this object:
SELECT EMPLOYEE_NAME
, EMPLOYEE_NUMBER
, EMPLOYEE_SOFI_NUMBER
, PERSON_ID
, DISABILITY_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, FTE
, DISABILITY_REASON
, STATUS
, CASUAL_INCIDENT
, INCIDENT_DATE
, REGISTRATION_ID
, REGISTRATION_ORGANIZATION
, REGISTRATION_DATE
, REGISTRATION_EXPIRY_DATE
, DESCRIPTION
, WORK_RESTRICTION
, DIABILITY_DEGREE
, WORK_RESUMPTION
, REMAINING_HOURS
, REMAINING_HOURS_UNITS
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
FROM APPS.PER_NL_WAO_LIST_V;
APPS.PER_NL_WAO_LIST_V is not referenced by any database object
|
|
|