SCR_AUDIT_CHK_V (SQL View)	Index Back
SCR Vendor Audit Check This view joins the fields on the Vendor Audit to the fields available for update from Supplier Change Request.

SCR_AUDIT_CHK_V

(SQL View)

SCR Vendor Audit Check

This view joins the fields on the Vendor Audit to the fields available for update from Supplier Change Request.

SELECT a.setid , a.template_id , c.recname , c.fieldname , a.audit_flag , a.reason_flag FROM PS_VNDR_AUDIT_DTL a , ps_scr_sys_data b , ps_scr_recfld_vw c WHERE a.recname = b.scr_upd_rec AND b.scr_src_rec = c.recname AND a.fieldname = c.fieldname AND a.audit_flag = 'Y' AND a.reason_flag ='Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Project Template

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

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

5 AUDIT_FLAG Character(1) VARCHAR2(1) NOT NULL Supplier Audit

6 REASON_FLAG Character(1) VARCHAR2(1) NOT NULL Reason Flag

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	TEMPLATE_ID	Character(30)	VARCHAR2(30) NOT NULL	Project Template
3	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
4	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
5	AUDIT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Supplier Audit
6	REASON_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Reason Flag