PC_SUM_TPL_LN (SQL Table)	Index Back
Summarization Template Summarization template identifies the fields that will be used in the "group by" for summing project transactions.

PC_SUM_TPL_LN

(SQL Table)

Summarization Template

Summarization template identifies the fields that will be used in the "group by" for summing project transactions.

# 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

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_PC_NONVW

4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
Prompt Table: %EDITTABLE

5 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)

6 REQUIRE_TYPE Character(1) VARCHAR2(1) NOT NULL An indicator that specifies whether a field is required or not.
C=Common
E=Project Reporting
N=Not Required
P=Required for Pricing
Q=Variance Pricing
R=Required

7 DATE_SUM_LEVEL Character(1) VARCHAR2(1) NOT NULL Date summarization level is used to decide which calendar to rollup dates to when summarizing transactions.
D=Daily
M=Monthly
Q=Quarterly
W=Weekly
Y=Yearly

8 ROLLUP_DATE_USED Character(1) VARCHAR2(1) NOT NULL Defines which date to use on summary rows: start of period date, or end of period date.
E=End of Period
S=Start of Period

9 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.

10 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.

11 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.

12 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.

#	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
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_PC_NONVW
4	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: %EDITTABLE
5	FIELDTYPE	Number(2,0)	SMALLINT NOT NULL	Field Type (from PSST0101 Ref.)
6	REQUIRE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	An indicator that specifies whether a field is required or not. C=Common E=Project Reporting N=Not Required P=Required for Pricing Q=Variance Pricing R=Required
7	DATE_SUM_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Date summarization level is used to decide which calendar to rollup dates to when summarizing transactions. D=Daily M=Monthly Q=Quarterly W=Weekly Y=Yearly
8	ROLLUP_DATE_USED	Character(1)	VARCHAR2(1) NOT NULL	Defines which date to use on summary rows: start of period date, or end of period date. E=End of Period S=Start of Period
9	FMS_DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the original entry.
10	FMS_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the original entry.
11	FMS_LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry.
12	FMS_LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry.