[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PER_PEOPLE_ASSIGNMENTS_V1 |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PER.PER_PEOPLE_ASSIGNMENTS_V1
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PERSON_ID | NUMBER | (10) | Person ID. | |
| BUSINESS_GROUP_ID | NUMBER | Business Group ID. | ||
| FULL_NAME | VARCHAR2 | (240) | Person Full Name. | |
| ORDER_NAME | VARCHAR2 | (240) | Person Order Name. | |
| EMPLOYEE_NUMBER | VARCHAR2 | (30) | Employee Number. | |
| APPLICANT_NUMBER | VARCHAR2 | (30) | Applicant Number. | |
| CURRENT_EMPLOYEE_FLAG | VARCHAR2 | (30) | Current Employee Flag. | |
| CURRENT_APPLICANT_FLAG | VARCHAR2 | (30) | Current Applicant Flag. | |
| ASSIGNMENT_NUMBER | VARCHAR2 | (30) | Assignment Number. | |
| ASSIGNMENT_TYPE | VARCHAR2 | (1) | Assignment Type. | |
| ORGANIZATION_ID | NUMBER | (15) | Organization ID. | |
| PAYROLL_ID | NUMBER | (9) | Payroll ID. | |
| PRIMARY_FLAG | VARCHAR2 | (30) | Primary Flag. | |
| 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. | ||
| GRADE_NAME | VARCHAR2 | (4000) | Grade Name. | |
| JOB_NAME | VARCHAR2 | (4000) | Job Name. | |
| POSITION_NAME | VARCHAR2 | (4000) | Position Name. | |
| ORG_NAME | VARCHAR2 | (4000) | Organization Name. | |
| PAYROLLS_NAME | VARCHAR2 | (80) | Payroll Name. | |
| P_TYPE | VARCHAR2 | (4000) | Person Type. | |
| MANAGER_FLAG | VARCHAR2 | (30) | Manager Flag. | |
| LOCATION_CODE | VARCHAR2 | (4000) | Location Code. | |
| SUP_NAME | VARCHAR2 | (240) | Supervisor Name. | |
| USER_STAT | VARCHAR2 | (4000) | Assignment Status | |
| ASSIGNMENT_ID | NUMBER | (10) | Assignment ID. | |
| EFFECTIVE_START_DATE | DATE | Assignment Effective Start Date. | ||
| EFFECTIVE_END_DATE | DATE | Assignment Effective End Date. | ||
| ASSIGNMENT_STATUS_TYPE_ID | NUMBER | (9) | Assignment Status Type ID. | |
| GRP_SEGMENT1 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRP_SEGMENT2 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRP_SEGMENT3 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRP_SEGMENT4 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRP_SEGMENT5 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRP_SEGMENT6 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRP_SEGMENT7 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRP_SEGMENT8 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRP_SEGMENT9 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRP_SEGMENT10 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRP_SEGMENT11 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRP_SEGMENT12 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRP_SEGMENT13 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRP_SEGMENT14 | VARCHAR2 | (60) | Key flexfield segment | |
| GRP_SEGMENT15 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRP_SEGMENT16 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRP_SEGMENT17 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRP_SEGMENT18 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRP_SEGMENT19 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRP_SEGMENT20 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRP_SEGMENT21 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRP_SEGMENT22 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRP_SEGMENT23 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRP_SEGMENT24 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRP_SEGMENT25 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRP_SEGMENT26 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRP_SEGMENT27 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRP_SEGMENT28 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRP_SEGMENT29 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRP_SEGMENT30 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRD_SEGMENT1 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRD_SEGMENT2 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRD_SEGMENT3 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRD_SEGMENT4 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRD_SEGMENT5 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRD_SEGMENT6 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRD_SEGMENT7 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRD_SEGMENT8 | VARCHAR2 | (60) | Key flexfield segment | |
| GRD_SEGMENT9 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRD_SEGMENT10 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRD_SEGMENT11 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRD_SEGMENT12 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRD_SEGMENT13 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRD_SEGMENT14 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRD_SEGMENT15 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRD_SEGMENT16 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRD_SEGMENT17 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRD_SEGMENT18 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRD_SEGMENT19 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRD_SEGMENT20 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRD_SEGMENT21 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRD_SEGMENT22 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRD_SEGMENT23 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRD_SEGMENT24 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRD_SEGMENT25 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRD_SEGMENT26 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRD_SEGMENT27 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRD_SEGMENT28 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRD_SEGMENT29 | VARCHAR2 | (60) | Key flexfield segment. | |
| GRD_SEGMENT30 | VARCHAR2 | (60) | Key flexfield segment. | |
| JOB_SEGMENT1 | VARCHAR2 | (60) | Key flexfield segment. | |
| JOB_SEGMENT2 | VARCHAR2 | (60) | Key flexfield segment. | |
| JOB_SEGMENT3 | VARCHAR2 | (60) | Key flexfield segment. | |
| JOB_SEGMENT4 | VARCHAR2 | (60) | Key flexfield segment. | |
| JOB_SEGMENT5 | VARCHAR2 | (60) | Key flexfield segment. | |
| JOB_SEGMENT6 | VARCHAR2 | (60) | Key flexfield segment. | |
| JOB_SEGMENT7 | VARCHAR2 | (60) | Key flexfield segment. | |
| JOB_SEGMENT8 | VARCHAR2 | (60) | Key flexfield segment. | |
| JOB_SEGMENT9 | VARCHAR2 | (60) | Key flexfield segment. | |
| JOB_SEGMENT10 | VARCHAR2 | (60) | Key flexfield segment. | |
| JOB_SEGMENT11 | VARCHAR2 | (60) | Key flexfield segment. | |
| JOB_SEGMENT12 | VARCHAR2 | (60) | Key flexfield segment. | |
| JOB_SEGMENT13 | VARCHAR2 | (60) | Key flexfield segment. | |
| JOB_SEGMENT14 | VARCHAR2 | (60) | Key flexfield segment. | |
| JOB_SEGMENT15 | VARCHAR2 | (60) | Key flexfield segment. | |
| JOB_SEGMENT16 | VARCHAR2 | (60) | Key flexfield segment. | |
| JOB_SEGMENT17 | VARCHAR2 | (60) | Key flexfield segment. | |
| JOB_SEGMENT18 | VARCHAR2 | (60) | Key flexfield segment. | |
| JOB_SEGMENT19 | VARCHAR2 | (60) | Key flexfield segment. | |
| JOB_SEGMENT20 | VARCHAR2 | (60) | Key flexfield segment. | |
| JOB_SEGMENT21 | VARCHAR2 | (60) | Key flexfield segment. | |
| JOB_SEGMENT22 | VARCHAR2 | (60) | Key flexfield segment. | |
| JOB_SEGMENT23 | VARCHAR2 | (60) | Key flexfield segment. | |
| JOB_SEGMENT24 | VARCHAR2 | (60) | Key flexfield segment. | |
| JOB_SEGMENT25 | VARCHAR2 | (60) | Key flexfield segment. | |
| JOB_SEGMENT26 | VARCHAR2 | (60) | Key flexfield segment. | |
| JOB_SEGMENT27 | VARCHAR2 | (60) | Key flexfield segment. | |
| JOB_SEGMENT28 | VARCHAR2 | (60) | Key flexfield segment. | |
| JOB_SEGMENT29 | VARCHAR2 | (60) | Key flexfield segment. | |
| JOB_SEGMENT30 | VARCHAR2 | (60) | Key flexfield segment. | |
| POS_SEGMENT1 | VARCHAR2 | (60) | Key flexfield segment. | |
| POS_SEGMENT2 | VARCHAR2 | (60) | Key flexfield segment. | |
| POS_SEGMENT3 | VARCHAR2 | (60) | Key flexfield segment. | |
| POS_SEGMENT4 | VARCHAR2 | (60) | Key flexfield segment. | |
| POS_SEGMENT5 | VARCHAR2 | (60) | Key flexfield segment. | |
| POS_SEGMENT6 | VARCHAR2 | (60) | Key flexfield segment. | |
| POS_SEGMENT7 | VARCHAR2 | (60) | Key flexfield segment. | |
| POS_SEGMENT8 | VARCHAR2 | (60) | Key flexfield segment. | |
| POS_SEGMENT9 | VARCHAR2 | (60) | Key flexfield segment. | |
| POS_SEGMENT10 | VARCHAR2 | (60) | Key flexfield segment. | |
| POS_SEGMENT11 | VARCHAR2 | (60) | Key flexfield segment. | |
| POS_SEGMENT12 | VARCHAR2 | (60) | Key flexfield segment. | |
| POS_SEGMENT13 | VARCHAR2 | (60) | Key flexfield segment. | |
| POS_SEGMENT14 | VARCHAR2 | (60) | Key flexfield segment. | |
| POS_SEGMENT15 | VARCHAR2 | (60) | Key flexfield segment. | |
| POS_SEGMENT16 | VARCHAR2 | (60) | Key flexfield segment. | |
| POS_SEGMENT17 | VARCHAR2 | (60) | Key flexfield segment. | |
| POS_SEGMENT18 | VARCHAR2 | (60) | Key flexfield segment. | |
| POS_SEGMENT19 | VARCHAR2 | (60) | Key flexfield segment. | |
| POS_SEGMENT20 | VARCHAR2 | (60) | Key flexfield segment. | |
| POS_SEGMENT21 | VARCHAR2 | (60) | Key flexfield segment. | |
| POS_SEGMENT22 | VARCHAR2 | (60) | Key flexfield segment. | |
| POS_SEGMENT23 | VARCHAR2 | (60) | Key flexfield segment. | |
| POS_SEGMENT24 | VARCHAR2 | (60) | Key flexfield segment. | |
| POS_SEGMENT25 | VARCHAR2 | (60) | Key flexfield segment. | |
| POS_SEGMENT26 | VARCHAR2 | (60) | Key flexfield segment. | |
| POS_SEGMENT27 | VARCHAR2 | (60) | Key flexfield segment. | |
| POS_SEGMENT28 | VARCHAR2 | (60) | Key flexfield segment. | |
| POS_SEGMENT29 | VARCHAR2 | (60) | Key flexfield segment. | |
| POS_SEGMENT30 | VARCHAR2 | (60) | Key flexfield segment. | |
| ASSIGNMENT_SEQUENCE | NUMBER | (15) | Assignment Sequence. | |
| NPW_NUMBER | VARCHAR2 | (30) | Non-Payroll Worker Number. | |
| CURRENT_NPW_FLAG | VARCHAR2 | (30) | Non-Payroll Worker Flag. | |
| GRADE_LADDER_NAME | VARCHAR2 | (240) | Grade Lader Name. |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, BUSINESS_GROUP_ID
, FULL_NAME
, ORDER_NAME
, EMPLOYEE_NUMBER
, APPLICANT_NUMBER
, CURRENT_EMPLOYEE_FLAG
, CURRENT_APPLICANT_FLAG
, ASSIGNMENT_NUMBER
, ASSIGNMENT_TYPE
, ORGANIZATION_ID
, PAYROLL_ID
, PRIMARY_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, GRADE_NAME
, JOB_NAME
, POSITION_NAME
, ORG_NAME
, PAYROLLS_NAME
, P_TYPE
, MANAGER_FLAG
, LOCATION_CODE
, SUP_NAME
, USER_STAT
, ASSIGNMENT_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, ASSIGNMENT_STATUS_TYPE_ID
, GRP_SEGMENT1
, GRP_SEGMENT2
, GRP_SEGMENT3
, GRP_SEGMENT4
, GRP_SEGMENT5
, GRP_SEGMENT6
, GRP_SEGMENT7
, GRP_SEGMENT8
, GRP_SEGMENT9
, GRP_SEGMENT10
, GRP_SEGMENT11
, GRP_SEGMENT12
, GRP_SEGMENT13
, GRP_SEGMENT14
, GRP_SEGMENT15
, GRP_SEGMENT16
, GRP_SEGMENT17
, GRP_SEGMENT18
, GRP_SEGMENT19
, GRP_SEGMENT20
, GRP_SEGMENT21
, GRP_SEGMENT22
, GRP_SEGMENT23
, GRP_SEGMENT24
, GRP_SEGMENT25
, GRP_SEGMENT26
, GRP_SEGMENT27
, GRP_SEGMENT28
, GRP_SEGMENT29
, GRP_SEGMENT30
, GRD_SEGMENT1
, GRD_SEGMENT2
, GRD_SEGMENT3
, GRD_SEGMENT4
, GRD_SEGMENT5
, GRD_SEGMENT6
, GRD_SEGMENT7
, GRD_SEGMENT8
, GRD_SEGMENT9
, GRD_SEGMENT10
, GRD_SEGMENT11
, GRD_SEGMENT12
, GRD_SEGMENT13
, GRD_SEGMENT14
, GRD_SEGMENT15
, GRD_SEGMENT16
, GRD_SEGMENT17
, GRD_SEGMENT18
, GRD_SEGMENT19
, GRD_SEGMENT20
, GRD_SEGMENT21
, GRD_SEGMENT22
, GRD_SEGMENT23
, GRD_SEGMENT24
, GRD_SEGMENT25
, GRD_SEGMENT26
, GRD_SEGMENT27
, GRD_SEGMENT28
, GRD_SEGMENT29
, GRD_SEGMENT30
, JOB_SEGMENT1
, JOB_SEGMENT2
, JOB_SEGMENT3
, JOB_SEGMENT4
, JOB_SEGMENT5
, JOB_SEGMENT6
, JOB_SEGMENT7
, JOB_SEGMENT8
, JOB_SEGMENT9
, JOB_SEGMENT10
, JOB_SEGMENT11
, JOB_SEGMENT12
, JOB_SEGMENT13
, JOB_SEGMENT14
, JOB_SEGMENT15
, JOB_SEGMENT16
, JOB_SEGMENT17
, JOB_SEGMENT18
, JOB_SEGMENT19
, JOB_SEGMENT20
, JOB_SEGMENT21
, JOB_SEGMENT22
, JOB_SEGMENT23
, JOB_SEGMENT24
, JOB_SEGMENT25
, JOB_SEGMENT26
, JOB_SEGMENT27
, JOB_SEGMENT28
, JOB_SEGMENT29
, JOB_SEGMENT30
, POS_SEGMENT1
, POS_SEGMENT2
, POS_SEGMENT3
, POS_SEGMENT4
, POS_SEGMENT5
, POS_SEGMENT6
, POS_SEGMENT7
, POS_SEGMENT8
, POS_SEGMENT9
, POS_SEGMENT10
, POS_SEGMENT11
, POS_SEGMENT12
, POS_SEGMENT13
, POS_SEGMENT14
, POS_SEGMENT15
, POS_SEGMENT16
, POS_SEGMENT17
, POS_SEGMENT18
, POS_SEGMENT19
, POS_SEGMENT20
, POS_SEGMENT21
, POS_SEGMENT22
, POS_SEGMENT23
, POS_SEGMENT24
, POS_SEGMENT25
, POS_SEGMENT26
, POS_SEGMENT27
, POS_SEGMENT28
, POS_SEGMENT29
, POS_SEGMENT30
, ASSIGNMENT_SEQUENCE
, NPW_NUMBER
, CURRENT_NPW_FLAG
, GRADE_LADDER_NAME
FROM APPS.PER_PEOPLE_ASSIGNMENTS_V1;
APPS
BEN_PGM_F
FND_SESSIONS
HR_GENERAL
- show dependent code
HR_PERSON_NAME
- show dependent code
HR_PERSON_TYPE_USAGE_INFO
- show dependent code
HR_SECURITY
- show dependent code
PAY_ALL_PAYROLLS_F
PAY_PEOPLE_GROUPS
PER_ALL_ASSIGNMENTS_F
PER_ASSIGNMENTS_F
PER_GRADES
PER_GRADES_TL
PER_GRADE_DEFINITIONS
PER_JOBS
PER_JOBS_TL
PER_JOB_DEFINITIONS
PER_PEOPLE_F
PER_PERSON_TYPES_TL
PER_POSITION_DEFINITIONS
PUBLIC
PER_PEOPLE_ASSIGNMENTS_V1
|
|
|
|