GPES_FDI_VW(SQL View) |
Index Back |
---|---|
FDI Data for EmployeesFDI Data for Employees |
SELECT DISTINCT GPES_SENDING_ID , GPES_CONFIRM_SEND FROM PS_GPES_ABSEVT_NT WHERE GPES_SENDING_ID <> ' ' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GPES_SENDING_ID | Character(10) | VARCHAR2(10) NOT NULL | Sending ID |
2 | GPES_CONFIRM_SEND | Character(1) | VARCHAR2(1) NOT NULL |
Confirmed Send
1=Included in FDI N=No Communicated Y=FDI Sent Confirmed Default Value: N |