MC_TEM_CRIT_VW (SQL View)	Index Back
Mass Change Tem Criteria View

MC_TEM_CRIT_VW

(SQL View)

Mass Change Tem Criteria View

select distinct mc_type_id, mc_stmnt_seq, recname from PS_MC_TYPE_RECORD where mc_record_type in ('D','U','S','B','T','M')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 MC_TYPE_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Type ID

2 MC_STMNT_SEQ Number(3,0) SMALLINT NOT NULL Mass Change Statement Sequence

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MC_TYPE_ID	Character(30)	VARCHAR2(30) NOT NULL	Mass Change Type ID
2	MC_STMNT_SEQ	Number(3,0)	SMALLINT NOT NULL	Mass Change Statement Sequence
3	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).