HRS_REC_HJ_VW (SQL View)	Index Back
Records Records which can be used for building Hot Job definition SQL.

HRS_REC_HJ_VW

(SQL View)

Records

Records which can be used for building Hot Job definition SQL.

SELECT A.RECNAME FROM PSRECDEFN A WHERE ((A.RECNAME IN ('HRS_JO_I','HRS_JO_POST_I','HRS_POSN_DTA_I2') AND EXISTS ( SELECT 'X' FROM PS_INSTALLATION WHERE POSITION_MGMT <> 'N')) OR (A.RECNAME IN ('HRS_JO_I','HRS_JO_POST_I') AND EXISTS ( SELECT 'X' FROM PS_INSTALLATION WHERE POSITION_MGMT = 'N')))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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