PY_GARN_PROR_VW

(SQL View)
Index Back

Garnishment Prorate View

This view is used as prompt for Proration Rule ID on Garnishment Specification Data 7 pages.

SELECT STATE_GARN_PRORATE , PRORATE_TYPE , EFFDT , GARN_PRORATE_RL_ID , DESCR FROM PS_GARN_PRORATE_RL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 STATE_GARN_PRORATE Character(6) VARCHAR2(6) NOT NULL Proration Rule State

Prompt Table: STATE_NAMES_VW

2 PRORATE_TYPE Character(1) VARCHAR2(1) NOT NULL Proration Type
S=SUPPORT
W=WRITS
3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 GARN_PRORATE_RL_ID Character(6) VARCHAR2(6) NOT NULL Garnishment Proration Rule ID

Prompt Table: GARN_PRORATE_DF

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