ORG_RCRDS_VIEW (SQL View)	Index Back
Change/Delete EXT_ORG_ID Flds This view is used in a process similar to the EMPLID Change/Delete process. The system uses ORG_RCRDS_VIEW and ORG_RCRDS_VW2 during the process of changing or deleting an organization ID from the database. ORG_RCRDS_VIEW processes records keyed by EXT_ORG_ID. ORG_RCRDS_VW2 processes records containing ID-like fields that are not named EXT_ORG_ID, such as MANAGER_ID.

ORG_RCRDS_VIEW

(SQL View)

Change/Delete EXT_ORG_ID Flds

This view is used in a process similar to the EMPLID Change/Delete process. The system uses ORG_RCRDS_VIEW and ORG_RCRDS_VW2 during the process of changing or deleting an organization ID from the database. ORG_RCRDS_VIEW processes records keyed by EXT_ORG_ID. ORG_RCRDS_VW2 processes records containing ID-like fields that are not named EXT_ORG_ID, such as MANAGER_ID.

SELECT A.RECNAME FROM PSRECFIELD A , PSRECDEFN B WHERE A.FIELDNAME = 'EXT_ORG_ID' AND A.RECNAME = B.RECNAME AND B.RECTYPE = 0 AND B.RECNAME NOT LIKE 'AUDIT%' AND B.RECNAME NOT LIKE '%AET'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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