[Home] [Help]
View: PSB_POSITION_ASSIGN_EMP_V
Product: | PSB - Public Sector Budgeting (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PAS.ROWID
, PAS.POSITION_ASSIGNMENT_ID
, PAS.DATA_EXTRACT_ID
, PAS.WORKSHEET_ID
, PAS.POSITION_ID
, PAS.EMPLOYEE_ID
, PE.EMPLOYEE_NUMBER
, PE.FULL_NAME
, PAS.PRIMARY_EMPLOYEE_FLAG
, PAS.EFFECTIVE_START_DATE
, PAS.EFFECTIVE_END_DATE
, PAS.LAST_UPDATE_DATE
, PAS.LAST_UPDATED_BY
, PAS.LAST_UPDATE_LOGIN
, PAS.CREATED_BY
, PAS.CREATION_DATE
FROM PSB_POSITION_ASSIGNMENTS PAS
, PSB_EMPLOYEES PE
WHERE PAS.EMPLOYEE_ID = PE.EMPLOYEE_ID
AND PAS.ASSIGNMENT_TYPE = 'EMPLOYEE'
Columns
Name |
ROW_ID |
POSITION_ASSIGNMENT_ID |
DATA_EXTRACT_ID |
WORKSHEET_ID |
POSITION_ID |
EMPLOYEE_ID |
EMPLOYEE_NUMBER |
FULL_NAME |
PRIMARY_EMPLOYEE_FLAG |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |