EM_MG_ANALYZE

(SQL Table)
Index Back

Master Agreement Analysis

Master Agreement Analysis

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EM_MG_CF_COMBO Number(9,0) DECIMAL(9) NOT NULL Chartfield Combination ID
2 EM_MG_NBR_MG Number(9,0) DECIMAL(9) NOT NULL Number of Master Agreements
3 EM_MG_NBR_DTL Number(9,0) DECIMAL(9) NOT NULL Number of Detail Agreements
4 EM_MG_NBR_SKP Number(9,0) DECIMAL(9) NOT NULL Number of Agreements Bypassed
5 EM_USE_MG Character(1) VARCHAR2(1) NOT NULL Use Master Agreement
6 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance