FS_SD_KEYFLD (SQL View)	Index Back
Key Fields View of fields defined as part of the primary unique key on a record. Similar to PSRECFLDKEYVW except that view only works for records that are of Record Type SQL Table. This view also displays unique keys on records based solely on PeopleTools Record MetaData, i.e. works for views and work records also.

FS_SD_KEYFLD

(SQL View)

Key Fields

View of fields defined as part of the primary unique key on a record. Similar to PSRECFLDKEYVW except that view only works for records that are of Record Type SQL Table. This view also displays unique keys on records based solely on PeopleTools Record MetaData, i.e. works for views and work records also.

SELECT A.RECNAME ,A.FIELDNAME FROM PSRECFIELDALL A WHERE %DecMult(%Round(%DECDIV(A.USEEDIT,2),0 ) , 2) <> A.USEEDIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RECORDNAME Character(15) VARCHAR2(15) NOT NULL Record Name
01=MASTER_ITEM_EC
02=INV_ITEMS_EC
03=BU_ITM_INV_EC
04=BU_ITM_WTVL_EC
05=ITEM_SUPPLIER_EC
06=ITM_SUPP_LOC_EC
07=ITM_VNDR_UOM_EC
08=ITM_VND_UMPR_EC
09=INV_ITM_UOM_EC
10=PUR_ITM_ATTR_EC
13=EN_REVISION_EC
14=ITEM_MFG_GPO_EC
15=ITEM_MFG_EC
16=ITEM_CAT_EC

2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECORDNAME	Character(15)	VARCHAR2(15) NOT NULL	Record Name 01=MASTER_ITEM_EC 02=INV_ITEMS_EC 03=BU_ITM_INV_EC 04=BU_ITM_WTVL_EC 05=ITEM_SUPPLIER_EC 06=ITM_SUPP_LOC_EC 07=ITM_VNDR_UOM_EC 08=ITM_VND_UMPR_EC 09=INV_ITM_UOM_EC 10=PUR_ITM_ATTR_EC 13=EN_REVISION_EC 14=ITEM_MFG_GPO_EC 15=ITEM_MFG_EC 16=ITEM_CAT_EC
2	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).