EX_TETIPSUM_TMP(SQL Table) |
Index Back |
|---|---|
EX TIP Summ. by GL BU and Dpt.EX Transactions in Progress Summarized Temporary Table to create summarized tables by GL Business Unit, Department, PC Business Unit and Project ID. It is used only in Application Engine EX_TIP_LOAD. Time Reports Data |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TIME_SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Time Sheet Unique Identifier (System Generated) |
| 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 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 6 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 7 | 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 |