AV_CNST_AC_O_VW

(SQL View)
Index Back

Constituent action

Organization Constituent action Prompt. Use this view as a prompt for organzations with constituent actions.

SELECT INSTITUTION, EXT_ORG_ID, CNST_ACTN_NO FROM PS_AV_CNST_ACTN WHERE EXT_ORG_ID <> ' '

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

Default Value: AV_OPR_DEF_TBL.INSTITUTION

Prompt Table: INSTITUTN_SCRTY

2 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

Prompt Table: EXT_ORG_TBL

3 CNST_ACTN_NO Character(10) VARCHAR2(10) NOT NULL Action Nbr

Default Value: NEW