[Home] [Help]
[Dependency Information]
[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) | Yes | 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
HR_ALL_ORGANIZATION_UNITS
HR_GENERAL
- show dependent code
PER_ALL_PEOPLE_F
PER_DISABILITIES_F
PER_WORK_INCIDENTS
PUBLIC
PER_NL_WAO_LIST_V
|
|
|
|