DEP_FEE_SRCH

(SQL View)
Index Back

Deposit Fees search record


SELECT DISTINCT INSTITUTION , BATCH_ID , OPRID , PGM_RUN_DATE FROM PS_DEP_FEE_CALC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

2 BATCH_ID Character(12) VARCHAR2(12) NOT NULL Batch ID
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 PGM_RUN_DATE Date(10) DATE NOT NULL Program Run Date