CAEDD_TRAN_VW

(SQL View)
 Index Back

SELECT a.setid , a.vendor_id , a.federal_ein , a.rpt_federal_ein , a.edd_account_num , a.calendar_year , a.cntrct_begin_dt , a.cntrct_amt , a.cntrct_expire_dt , a.ongoing_contrct_sw , a.date_last_process , a.file_ext , b.first_name , b.middle_initial , b.last_name , b.ssn , a.descr254 FROM PS_CAEDD_VNDR_TRAN a , ps_caedd_vendor b WHERE a.setid = b.setid AND a.vendor_id = b.vendor_id AND a.federal_ein = b.federal_ein AND a.rpt_federal_ein = b.rpt_federal_ein AND a.edd_account_num = b.edd_account_num

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_WTHD_VW

3 FEDERAL_EIN Number(9,0) DECIMAL(9) NOT NULL Federal EIN
4 RPT_FEDERAL_EIN Number(9,0) DECIMAL(9) NOT NULL Reporting Federal EIN
5 EDD_ACCOUNT_NUM Number(8,0) INTEGER NOT NULL EDD Employer Account Number
6 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year
7 CNTRCT_BEGIN_DT Date(10) DATE Contract Begin Date
8 CNTRCT_AMT Number(14,2) DECIMAL(13,2) NOT NULL Contract Amount
9 CNTRCT_EXPIRE_DT Date(10) DATE Expire Date
10 ONGOING_CONTRCT_SW Character(1) VARCHAR2(1) NOT NULL Ongoing Contract

Y/N Table Edit

11 DATE_LAST_PROCESS Date(10) DATE Date Last Processed
12 FILE_EXT Number(3,0) SMALLINT NOT NULL File Ext
13 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
14 MIDDLE_INITIAL Character(1) VARCHAR2(1) NOT NULL Middle Initial
15 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
16 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #
17 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254