AMRECFLDEDITVW(SQL View) |
Index Back |
|---|---|
Search Edit Fields |
| SELECT A.RECNAME , A.FIELDNAME , A.FIELDNUM , CASE WHEN %Sql(AM_BITAND,A.USEEDIT,1) THEN 'Y' ELSE 'N' END , CASE WHEN %Sql(AM_BITAND,A.USEEDIT,2048) THEN 'Y' ELSE 'N' END , CASE WHEN %Sql(AM_BITAND,A.USEEDIT,32) THEN 'Y' ELSE 'N' END , CASE WHEN %Sql(AM_BITAND,A.USEEDIT,16) THEN 'Y' ELSE 'N' END , A.LABEL_ID , C.FIELDTYPE , C.LENGTH , C.DECIMALPOS FROM PSRECFIELDDB A , %Table(PSDBFIELD) C WHERE A.FIELDNAME = C.FIELDNAME AND (%Sql(AM_BITAND,A.USEEDIT,1) OR %Sql(AM_BITAND,A.USEEDIT,2048) OR %Sql(AM_BITAND,A.USEEDIT,32) OR %Sql(AM_BITAND,A.USEEDIT,16)) |
| # | 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). |
| 3 | FIELDNUM | Number(4,0) | SMALLINT NOT NULL | Field Number |
| 4 | KEY_FLG | Character(1) | VARCHAR2(1) NOT NULL | Key Field |
| 5 | SEARCH_KEY | Character(1) | VARCHAR2(1) NOT NULL | Search Key Item |
| 6 | LIST_BOX_ITEM | Character(1) | VARCHAR2(1) NOT NULL | List Box Item |
| 7 | KEY_ALTERNATE | Character(1) | VARCHAR2(1) NOT NULL | Key Alternate |
| 8 | LABEL_ID | Character(18) | VARCHAR2(18) NOT NULL | LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG. |
| 9 | FIELDTYPE | Number(2,0) | SMALLINT NOT NULL | Field Type (from PSST0101 Ref.) |
| 10 | LENGTH | Number(5,0) | INTEGER NOT NULL | Length |
| 11 | DECIMALPOS | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |