JPM_RLAT_RECVW1

(SQL View)
 Index Back

Record count

Counts those record key fields that have a matching non-key field in JOB, JOB_JR, or JOBCODE_TBL

SELECT F.RECNAME , COUNT(*) FROM PSKEYDEFN F WHERE F.INDEXID = '_' AND EXISTS ( SELECT 'X' FROM PSRECFIELDALL F1 WHERE F1.RECNAME IN ('JOB','JOB_JR', 'JOBCODE_TBL') AND F1.FIELDNAME = F.FIELDNAME AND %Truncate(F1.USEEDIT / 2, 0) * 2 = F1.USEEDIT) GROUP BY F.RECNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
2 JPM_FIELD_COUNT Number(3,0) SMALLINT NOT NULL Field Count