View: GHR_SF113_V

Product:	GHR - US Federal Human Resources
Description:	This view is used to generate SF-113A report.
Implementation/DBA Data:	APPS.GHR_SF113_V

View Text

SELECT DISTINCT PPF.PERSON_ID
, DECODE(PAST.PER_SYSTEM_STATUS
, 'ACTIVE_ASSIGN'
, '1'
, 'TERM_ASSIGN'
, 2
, 0) STATUS
, PA.EFFECTIVE_START_DATE
, PA.EFFECTIVE_END_DATE
, PA.ASSIGNMENT_ID
, PA.POSITION_ID
, PA.GRADE_ID
, PA.LOCATION_ID
FROM PER_ASSIGNMENTS_F PA
, PER_ASSIGNMENT_STATUS_TYPES PAST
, PER_PEOPLE_F PPF
, PER_GRADES PG
, PER_GRADE_DEFINITIONS PGD
WHERE (PAST.PER_SYSTEM_STATUS IN ('ACTIVE_ASSIGN'
, 'TERM_ASSIGN'))
AND (PA.ASSIGNMENT_TYPE <> 'B')
AND SUBSTR(PGD.SEGMENT1
, 1
, 2) NOT IN ('CC'
, 'NA'
, 'NL'
, 'NS')
AND PA.PRIMARY_FLAG = 'Y'
AND PA.ASSIGNMENT_STATUS_TYPE_ID = PAST.ASSIGNMENT_STATUS_TYPE_ID
AND (PA.GRADE_ID = PG.GRADE_ID)
AND (PG.GRADE_DEFINITION_ID = PGD.GRADE_DEFINITION_ID)
AND (PPF.PERSON_ID = PA.PERSON_ID)

Columns