HCR_SM_OREC_VW (SQL View)	Index Back
Search/Match Org Records Search Match Organization Records. This view selects only tables and views that have EXT_ORG_ID as one of the key fields.

HCR_SM_OREC_VW

(SQL View)

Search/Match Org Records

Search Match Organization Records. This view selects only tables and views that have EXT_ORG_ID as one of the key fields.

SELECT A.RECNAME , B.RECDESCR FROM PSRECFIELDDB A , PSRECDEFN B WHERE %DecMult(%Round(%DECDIV(A.USEEDIT,2),0 ) , 2) <> A.USEEDIT AND A.RECNAME = B.RECNAME AND B.RECTYPE NOT IN (2,3,7) AND A.FIELDNAME = 'EXT_ORG_ID'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

2 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
2	RECDESCR	Character(30)	VARCHAR2(30) NOT NULL	Record Description