RE_AM_LA_COUNT

(SQL View)
Index Back

SELECT A.BUSINESS_UNIT , B.BUSINESS_UNIT , A.ROWCOUNT1 , B.ROWCOUNT1 FROM PS_RE_AM_LS_COUNT A LEFT OUTER JOIN PS_RE_LS_COUNT B ON A.BUSINESS_UNIT = B.BUSINESS_UNIT_AM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 ROWCOUNT1 Number(12,0) DECIMAL(12) NOT NULL Row Count
4 ROWCOUNT2 Number(12,0) DECIMAL(12) NOT NULL Row Count