EMPLIDTRACKING_GROUPC=Completed
I=Initiated
TRACKING_GRP_VW(SQL View) |
Index Back |
|---|---|
Tracking Group ViewTRACKING_GRP_VW is used as a prompt in the letter generation process. If the 'One 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 = 'P' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee 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 |