SETIDDefault Value: AV_OPR_DEF_TBL.SETID
Prompt Table: SETID_TBL
AV_ACCT_SRCH(SQL View) |
Index Back |
|---|---|
Account Designation SearchA search record for the Designation Funds inquiry panel. ----------------------------------------------------------------------------------------------------------------- Modified on 12/19/2000, old SELECT read: SELECT DISTINCT SETID FROM PS_AV_ACCOUNT_TBL ----------------------------------------------------------------------------------------------------------------- |
| SELECT DISTINCT SETID , DESIGNATION , AV_DES_NAME FROM PS_AV_ACCOUNT_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: AV_OPR_DEF_TBL.SETID Prompt Table: SETID_TBL |
| 2 | DESIGNATION | Character(11) | VARCHAR2(11) NOT NULL | Designation |
| 3 | AV_DES_NAME | Character(30) | VARCHAR2(30) NOT NULL | Designation Name |