SETIDDESIGNATIONEFFDTTRIBUTE_NOPrompt Table: AV_PEOPLE_SRCH
AV_TRIB_TBL(SQL Table) |
Index Back |
|---|---|
Tribute TableTribute Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | DESIGNATION |
Character(11) | VARCHAR2(11) NOT NULL | Designation |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | TRIBUTE_NO |
Character(11) | VARCHAR2(11) NOT NULL | Tribute Nbr |
| 5 | AV_TRIB_ID | Character(11) | VARCHAR2(11) NOT NULL |
Tribute Recipient
Prompt Table: AV_PEOPLE_SRCH |
| 6 | CONSTITUENT_NAME | Character(50) | VARCHAR2(50) NOT NULL | Constituent |