GUARANTOR_VW2 (SQL View)	Index Back
Guarantor Table View Record used to define Guarantor information and processing options, by Aid Year.

GUARANTOR_VW2

(SQL View)

Guarantor Table View

Record used to define Guarantor information and processing options, by Aid Year.

SELECT GUAR_UNQ_ID, GUAR_OE_CD, DESCR FROM PS_GUARANTOR_TBL

Related Language Record: GUARANTOR_VW_LN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GUAR_UNQ_ID Number(3,0) SMALLINT NOT NULL Guarantor ID
Prompt Table: GUARANTOR_TBL

2 GUAR_OE_CD Character(3) VARCHAR2(3) NOT NULL Guarantor OE Code

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GUAR_UNQ_ID	Number(3,0)	SMALLINT NOT NULL	Guarantor ID Prompt Table: GUARANTOR_TBL
2	GUAR_OE_CD	Character(3)	VARCHAR2(3) NOT NULL	Guarantor OE Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description