WRKSHT_LINES_VW (SQL View)	Index Back
Worksheet Line Item Cash Forecast Worksheet Line Items

WRKSHT_LINES_VW

(SQL View)

Worksheet Line Item

Cash Forecast Worksheet Line Items

SELECT A.SETID , A.WRKSHEET_LINE_ITEM , A.LINE_ITEM_TYPE , A.WORKSHEET_ID FROM PS_WORKSHEET_LINES A WHERE A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_WORKSHEET_LINES WHERE SETID = A.SETID AND WORKSHEET_ID = A.WORKSHEET_ID AND LINE_ITEM_TYPE = A.LINE_ITEM_TYPE AND WRKSHEET_LINE_ITEM = A.WRKSHEET_LINE_ITEM)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SP_SETID_NONVW

2 WRKSHEET_LINE_ITEM Character(30) VARCHAR2(30) NOT NULL Cash Forecast Worksheet Line item

3 LINE_ITEM_TYPE Character(1) VARCHAR2(1) NOT NULL Line Item Type categorizes worksheet line items into cash flow items, non-cash flow items and totals.
1=Cash
2=Non-Cash

4 WORKSHEET_ID Character(20) VARCHAR2(20) NOT NULL Cash Flows Worksheet ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
2	WRKSHEET_LINE_ITEM	Character(30)	VARCHAR2(30) NOT NULL	Cash Forecast Worksheet Line item
3	LINE_ITEM_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Line Item Type categorizes worksheet line items into cash flow items, non-cash flow items and totals. 1=Cash 2=Non-Cash
4	WORKSHEET_ID	Character(20)	VARCHAR2(20) NOT NULL	Cash Flows Worksheet ID