PeopleSoft 9
Account Payables

Table Name CAEDD_CNTRL_BUS

Table Description
CAEDD_CNTRL_BUS
Columns
Name Datatype Is PK Is FK
FEDERAL_EIN int Yes Yes
RPT_FEDERAL_EIN int Yes No
EDD_ACCOUNT_NUM int Yes No
TRANSMITTER_FLG VARCHAR(1) No No
SSN VARCHAR(9) No No
NAME1 VARCHAR(40) No No
ADDRESS1 VARCHAR(55) No No
CITY VARCHAR(30) No No
STATE VARCHAR(6) No No
ZIP_CODE VARCHAR(5) No No
ZIP_CODE_EXT VARCHAR(4) No No
PHONE_NUM VARCHAR(12) No No
DATE_LAST_PROCESS PSDATE No No
FILE_EXT SMALLINT No No
TOTAL_IC_REPORTED SMALLINT No No
Index
Name Type Unique Member
PS_CAEDD_CNTRL_BUS PK Yes
Member(s) of "PS_CAEDD_CNTRL_BUS" Index
FEDERAL_EIN
RPT_FEDERAL_EIN
EDD_ACCOUNT_NUM

Published June 06, 2007