GROUP_TYPE_VW (SQL View)	Index Back
Group Type View Group Type View

GROUP_TYPE_VW

(SQL View)

Group Type View

select DISTINCT B.GROUP_BU, A.GROUP_TYPE FROM PS_GROUP_TYPE_TBL A, PS_GROUP_CONTROL B WHERE A.EFFDT <= %CURRENTDATEIN AND A.EFF_STATUS = 'A' AND A.GROUP_TYPE = B.GROUP_TYPE AND A.SETID = (SELECT SETID FROM PS_SET_CNTRL_REC WHERE RECNAME = 'GROUP_TYPE_TBL' AND SETCNTRLVALUE = B.GROUP_BU)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GROUP_BU Character(5) VARCHAR2(5) NOT NULL Represents the high level grouping of multiple general ledger business units.

2 GROUP_TYPE Character(1) VARCHAR2(1) NOT NULL Specifies a category of transactions included in a group of receivables pending items. The group type affects processing of the transactions and is useful for as a sort/selection option for reports and inquiries. Examples of group type are Billing (for invoices) Payments and Transfers.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GROUP_BU	Character(5)	VARCHAR2(5) NOT NULL	Represents the high level grouping of multiple general ledger business units.
2	GROUP_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Specifies a category of transactions included in a group of receivables pending items. The group type affects processing of the transactions and is useful for as a sort/selection option for reports and inquiries. Examples of group type are Billing (for invoices) Payments and Transfers.