FT_ASGN_RSN_VW

(SQL View)
Index Back

Assignment Audit Actions

Assignment Audit Report Actions

SELECT DISTINCT STG.FT_RUN_ID , ACTRSN.ACTION , ACTRSN.ACTION_REASON FROM %Table(FT_ASSIGNMNT_IN) STG , %Table(ACTN_REASON_TBL) ACTRSN WHERE STG.ACTION = ACTRSN.ACTION AND STG.ACTION_REASON = ACTRSN.ACTION_REASON AND %EffdtCheck(ACTN_REASON_TBL ACTRSN2, ACTRSN, FT_EFF_START_DATE) AND ACTRSN.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FT_RUN_ID Number(18,0) DECIMAL(18) NOT NULL LEGAL_ENTITY_ID
2 ACTION Character(3) VARCHAR2(3) NOT NULL Action
3 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code