INSTITUTIONGCLUB_CDPrompt Table: AV_GCLUB_OWN_VW
EMPLIDEXT_ORG_IDFISCAL_YEARPrompt Table: CAL_FISYR_VW
LANGUAGE_CDAVGCLUBMBRLNG(SQL Table) |
Index Back |
|---|---|
Rel Lng Giving Club MemberAVGCLUBMBRLNG is the language record related to AV_GCLUB_MBR A related language record enables text fields on a table to be translated into various languages for use in other countries. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | GCLUB_CD |
Character(9) | VARCHAR2(9) NOT NULL |
Giving Club Code
Prompt Table: AV_GCLUB_OWN_VW |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
| 5 | FISCAL_YEAR |
Number(4,0) | SMALLINT NOT NULL |
Fiscal Year
Prompt Table: CAL_FISYR_VW |
| 6 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | DESCRLONG | Long Character | CLOB | Long Description |