GPDE_FM_FORM_IDGPDE_FM_SRCH(SQL View) |
Index Back |
|---|---|
Certificates - Form Serch ViewCertificates - Form Serch View |
| SELECT A.GPDE_FM_FORM_ID ,A.EFFDT ,A.DESCR FROM PS_GPDE_FM_DEF A WHERE A.EFFDT = ( SELECT MAX(sub.EFFDT) FROM PS_GPDE_FM_DEF sub WHERE sub.GPDE_FM_FORM_ID = A.GPDE_FM_FORM_ID) AND EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPDE_FM_FORM_ID |
Character(12) | VARCHAR2(12) NOT NULL | ID of PDF Form |
| 2 | EFFDT | Date(10) | DATE | Effective Date |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |