MC_TYPE_WRK7

(SQL View)
Index Back

MC Type Statement copy work


select mc_type_id, mc_stmnt_seq, descr, mc_free_form_sw, mc_arch_to_file_sw from ps_mc_type_stmnt

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 MC_FREE_FORM_SW Character(1) VARCHAR2(1) NOT NULL Free Form SQL

Y/N Table Edit

Default Value: N

5 MC_ARCH_TO_FILE_SW Character(1) VARCHAR2(1) NOT NULL Mass Change Arch to File Swch

Y/N Table Edit

Default Value: N