PC_SUM_TPL_VW (SQL View)	Index Back
View of Sum Template Sequences Prompt view of all summarization template sequences.

PC_SUM_TPL_VW

(SQL View)

View of Sum Template Sequences

Prompt view of all summarization template sequences.

SELECT A.PRODUCT_CODE , A.PROCESSING_SEQ FROM PS_PC_SUM_TPL_HDR A WHERE A.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PRODUCT_CODE Character(4) VARCHAR2(4) NOT NULL Feeder integration product code
3RD=Third Party Loader
APPO=Payables / Purchasing
EX=Expenses
GL=General Ledger
GRFA=Grants Retroactive F&A
PRC=Pricing Engine
RPT1=Project Reporting Tables
TL=Time and Labor
USR1=User 1
USR2=User 2
USR3=User 3
USR4=User 4
USR5=User 5
VP=Variance Pricing

2 PROCESSING_SEQ Number(5,0) INTEGER NOT NULL Processing Sequence

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PRODUCT_CODE	Character(4)	VARCHAR2(4) NOT NULL	Feeder integration product code 3RD=Third Party Loader APPO=Payables / Purchasing EX=Expenses GL=General Ledger GRFA=Grants Retroactive F&A PRC=Pricing Engine RPT1=Project Reporting Tables TL=Time and Labor USR1=User 1 USR2=User 2 USR3=User 3 USR4=User 4 USR5=User 5 VP=Variance Pricing
2	PROCESSING_SEQ	Number(5,0)	INTEGER NOT NULL	Processing Sequence