EX_ERTIPSGD_TBL (SQL Table)	Index Back
EX TIP Summ. by GL BU and Dpt. EX Transactions in Progress Summarized Table by GL Business Unit and Department to be used in EX TIP Pagelets. Expense Reports Data

EX_ERTIPSGD_TBL

(SQL Table)

EX TIP Summ. by GL BU and Dpt.

EX Transactions in Progress Summarized Table by GL Business Unit and Department to be used in EX TIP Pagelets. Expense Reports Data

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID

2 TIP_STAGE Character(7) VARCHAR2(7) NOT NULL Transactions In Progress

3 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

4 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

5 DAYS_INACT_RANGE Character(3) VARCHAR2(3) NOT NULL Days Inactive Range
-30=< 31
30=31 to 60
60=61 to 90
90+=> 90
A=All

6 COUNTER Number(10,0) DECIMAL(10) NOT NULL Counter

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Report ID
2	TIP_STAGE	Character(7)	VARCHAR2(7) NOT NULL	Transactions In Progress
3	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
4	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
5	DAYS_INACT_RANGE	Character(3)	VARCHAR2(3) NOT NULL	Days Inactive Range -30=< 31 30=31 to 60 60=61 to 90 90+=> 90 A=All
6	COUNTER	Number(10,0)	DECIMAL(10) NOT NULL	Counter