T4A_MAPID_VW

(SQL View)
Index Back

T4A Map Definition View

T4A Map Definition View

SELECT 'T4A' , H.FS_MAP_ID , H.DESCR , H.VERSION FROM PS_FS_MAP_HDR_TBL H , PS_FS_MAP_SRC_HDR S , PS_FS_MAP_TRG_HDR T WHERE H.FS_MAP_ID = S.FS_MAP_ID AND H.FS_MAP_ID = T.FS_MAP_ID AND S.FS_MAP_ID = T.FS_MAP_ID AND H.FS_MAP_ACT_FLG = 'Y' AND H.FS_MAP_STATUS = 'R' AND S.FS_MAP_NODE_TYP = 'D' AND T.FS_MAP_NODE_TYP = 'X' AND S.FS_MAP_RELT_TYPE = 'T' AND T.FS_MAP_RELT_TYPE = 'X' AND H.OBJECTOWNERID = 'FAP' AND S.IB_SCHEMANAME = 'AP_T4A' AND T.FS_MAP_SAMPLEFILE = 'T4A.XML'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 WTHD_RPT_ID Character(10) VARCHAR2(10) NOT NULL Withholding Report ID
2 FS_MAP_ID Character(30) VARCHAR2(30) NOT NULL Map ID
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference