WF_HR_TRN_RECVW(SQL View) |
Index Back |
|---|---|
Guided Self Service PageFieldsShows all fields that are on both Record HR_GSS_PG_FLDS and the page that is defined on the config page (i.e. HR_MSS_CT_JOB_SBF). It will not show fields that are keys on job or compensation that are hidden (fielduse NOT IN (3,19,27) ) that have no label ( LBLTEXT <> ' ') that are in a grid or scroll area (OCCURSLEVEL = 0) |
| SELECT DISTINCT A.PNLNAME , B.RECNAME , A.FIELDNAME , A.LBLTEXT , A.FIELDUSE FROM PSPNLFIELD A , PSRECFIELD B WHERE B.RECNAME = 'HR_GSS_PG_FLDS' AND A.FIELDNAME = B.FIELDNAME AND A.DSPLFORMAT <> 10485768 AND NOT EXISTS ( SELECT 'X' FROM PSRECFLDKEYVW A1 WHERE A1.FIELDNAME = A.FIELDNAME AND A1.RECNAME IN ('JOB', 'COMPENSATION')) AND LBLTEXT <> ' ' AND OCCURSLEVEL = 0 AND fielduse NOT IN (3,19,27) AND FIELDUSE = ( SELECT MIN(FIELDUSE) FROM PSPNLFIELD C WHERE C.FIELDNAME = A.FIELDNAME AND a.pnlname = C.PNLNAME AND A.DSPLFORMAT <> 10485768 AND fielduse NOT IN (3,19,27) ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PNLNAME | Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). |
| 2 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 3 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 4 | LBLTEXT | Character(60) | VARCHAR2(60) NOT NULL | Label Text |
| 5 | FIELDUSE | Number(10,0) | DECIMAL(10) NOT NULL | Panel Field Use |