PYAP_UNXTRC_TAO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
3	INVOICE_ID	Character(22)	VARCHAR2(22) NOT NULL	Invoice Number
4	SEQUENCENO	Number(10,0)	DECIMAL(10) NOT NULL	Sequence Number
5	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
6	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
7	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
8	PAY_END_DT	Date(10)	DATE	Pay Period End Date
9	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ?
10	PAGE_NUM	Number(4,0)	SMALLINT NOT NULL	Page #
11	LINE_NUM	Number(2,0)	SMALLINT NOT NULL	Line #
12	SEPCHK	Number(1,0)	SMALLINT NOT NULL	Separate check number.
13	BENEFIT_RCD_NBR	Number(3,0)	SMALLINT NOT NULL	Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.
14	PLAN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
15	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan
16	DEDCD	Character(6)	VARCHAR2(6) NOT NULL	Deduction Code
17	DED_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Deduction Classification A=After-Tax B=Before-Tax L=QC Taxable Benefit N=Nontaxable Benefit P=Nontaxable Btax Benefit T=Taxable Benefit
18	DED_SLSTX_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Sales Tax Type B=None G=Goods and Services Tax H=Harmonized Sales Tax I=Provincial Sales Tax Insurance P=Provincial Sales Tax Q=QC Prov Sales Tax Insurance S=QC Provincial Sales Tax T=Provincial Premium Tax U=QC Provincial Premium Tax
19	GARN_PRIORITY	Number(3,0)	SMALLINT NOT NULL	Garnish Priority
20	GARNID	Character(6)	VARCHAR2(6) NOT NULL	Garnish ID
21	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
22	BOND_ID	Character(3)	VARCHAR2(3) NOT NULL	Savings Bond ID
23	BOND_OWNER_ID	Character(2)	VARCHAR2(2) NOT NULL	Bond Owner ID
24	BOND_OTH_REG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Bond Other Registrant Type B=Beneficiary C=Co-Owner N=No Other Bond Registrant
25	BOND_OTH_REG_ID	Character(2)	VARCHAR2(2) NOT NULL	Bond Other Registrant ID
26	BOND_LOG_SEQ	Number(3,0)	SMALLINT NOT NULL	Bond Activity Seq #
27	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
28	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality
29	TAX_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Tax Balance Class
30	TAX_CLASS_CAN	Character(3)	VARCHAR2(3) NOT NULL	Canadian Tax Class ALL=Total Gross CBT=Canadian Bonus Tax CIT=Canadian Income Tax (T4) CPA=Pension Adjustment CPP=Canada Pension Plan Employee CPR=Canada Pension Plan Employer EIE=Employment Insurance Employee EIR=Employment Insurance Employer HTX=Provincial Health Tax PYT=Payroll Tax QBT=Quebec Bonus Tax QCD=Quebec Tax Deduction QIE=Quebec Parental Plan Employee QIR=Quebec Parental Plan Employer QIT=Quebec Income Tax (RL-1) QPP=Quebec Pension Plan Employee QPR=Quebec Pension Plan Employer RV2=Quebec Income Tax (RL-2) T4A=Canadian Income Tax (T4A) TRV=True RL TT4=True T4
31	TAX_GRP_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Tax Type
32	TAX_TYPE_CAN	Character(4)	VARCHAR2(4) NOT NULL	Tax Type
33	PROVINCE	Character(6)	VARCHAR2(6) NOT NULL	Province
34	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
35	AMOUNT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Commuting Allowance Paid Per Cycle.
36	PAY_MODE	Character(1)	VARCHAR2(1) NOT NULL	Pay Mode B=Pay when Bond Price met C=Pay when Collection Completed D=Pay as Deducted S=Pay at Specified Date
37	SEPARATE_AP_PAYMNT	Character(1)	VARCHAR2(1) NOT NULL	Separate AP Payment Y/N Table Edit
38	EXTRACT_TYPE_LINE	Character(1)	VARCHAR2(1) NOT NULL	Extract Type B=Benefit D=Deduction G=Garnishment T=Tax
39	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
40	DEPTID_CF	Character(10)	VARCHAR2(10) NOT NULL	Department
41	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project/Grant
42	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product
43	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
44	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code
45	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Public Sector Financials Chart Field.
46	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Public Sector Financials Chart Field
47	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit
48	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
49	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Chartfield
50	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield number 1
51	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2
52	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3
53	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1
54	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate
55	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
56	SEND_TO_AP	Character(1)	VARCHAR2(1) NOT NULL	Send to AP
57	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values