OPRIDEMPLIDEMPL_RCDEFFDTDefault Value: %date
EFFSEQGVT_EDIT_PREFIXGVT_EDIT_CATEGORYGVT_EDIT_ID1=Status
2=Dynamic
3=Status and Dynamic
4=Pine
GVT_CPDF_ERR_VW(SQL View) |
Index Back |
|---|---|
CPDF Error TableCPDF error view for Create/View Personnel Actions |
| SELECT a.OPRID ,a.EMPLID ,a.EMPL_RCD ,a.EFFDT , a.EFFSEQ ,a.GVT_EDIT_PREFIX , a.GVT_EDIT_CATEGORY ,a.GVT_EDIT_ID , b.xlatlongname ,a.GVT_CPDF_ERRORMSG ,a.GVT_EDIT_PREFIX ||'.'||a.GVT_EDIT_CATEGORY ||'.'||a.GVT_EDIT_ID FROM PS_GVT_CPDF_ERR_OL a , PSXLATITEM b WHERE b.fieldname='GVT_EDIT_ID' AND B.FIELDVALUE=a.GVT_EDIT_ID AND B.EFFDT=( SELECT MAX(EFFDT) FROM PSXLATITEM C WHERE C.fieldname='GVT_EDIT_ID' AND C.FIELDVALUE=A.GVT_EDIT_ID AND C.EFFDT<=%CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 6 | GVT_EDIT_PREFIX |
Character(3) | VARCHAR2(3) NOT NULL | Edit Prefix |
| 7 | GVT_EDIT_CATEGORY |
Character(3) | VARCHAR2(3) NOT NULL | Edit Category |
| 8 | GVT_EDIT_ID |
Character(1) | VARCHAR2(1) NOT NULL |
Edit ID
1=Status 2=Dynamic 3=Status and Dynamic 4=Pine |
| 9 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |
| 10 | GVT_CPDF_ERRORMSG | Character(254) | VARCHAR2(254) NOT NULL | Error Message Definition |
| 11 | GVT_CPDF_ERRORMSG1 | Character(11) | VARCHAR2(11) NOT NULL | CPDF error message |