TRK_GRP_ORG_VW

(SQL View)
 Index Back

Tracking Group Org View

TRK_GRP_ORG_VW is used as a prompt in the letter generation process. If the 'One Org ID' option was specified, this view will be used to show the user those tracking groups which belong to the ID selected.

SELECT DISTINCT A.COMMON_ID , A.Tracking_Group , A.Group_Status FROM PS_TRACKING_GRPS A WHERE SA_ID_TYPE = 'O'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
2 TRACKING_GROUP Character(6) VARCHAR2(6) NOT NULL Tracking Group
3 GROUP_STATUS Character(1) VARCHAR2(1) NOT NULL Group Status
C=Completed
I=Initiated