RECNAMEFIELDNAMEEODP_RECFLD_VW(SQL View) |
Index Back |
|---|---|
Record Prompt ViewRecord Prompt View |
| SELECT DISTINCT a.RECNAME , a.FIELDNAME FROM PSRECFIELD a ,PS_EODP_RECFIELD b WHERE a.RECNAME=b.RECNAME AND a.FIELDNAME=b.FIELDNAME AND (%Sql(EODP_BITAND_ALL_PLATFORMS, a.USEEDIT, 16) = 16 OR %Sql(EODP_BITAND_ALL_PLATFORMS, a.USEEDIT, 32) = 32 OR %Sql(EODP_BITAND_ALL_PLATFORMS, a.USEEDIT, 2048) = 2048) AND (b.EODP_SNSTV='Y' OR b.EODP_PERS_IDFR='Y') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 2 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |