FO_TG_RVRSE_VW

(SQL View)
 Index Back

SELECT FO_OI_TG_NAME , FO_OI_TG_VER , FO_OI_TG_ID , FO_OI_TG_STATUS FROM PS_FO_TGROUP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FO_OI_TG_NAME Character(15) VARCHAR2(15) NOT NULL Transaction Group Name
2 FO_OI_TG_VER Number(4,0) SMALLINT NOT NULL Transaction Group Version
3 FO_OI_TG_ID Number(15,0) DECIMAL(15) NOT NULL Transaction Group ID
4 FO_OI_TG_STATUS Character(3) VARCHAR2(3) NOT NULL Transaction Group Status (Active/Deprecated/In Progress/Retired)
10=Active
20=Deprecated
30=In Progress
40=Retired