AV_RUNCTL_GCLUB(SQL Table) |
Index Back |
|---|---|
Giving Clubs Run ControlRecord is used to setup parameters for Giving Club processing. 04/16/01 (JPM) - I removed the av_install_inst.base_currency default that was on the currency_cd field. This field needs to be populated based on the Institution that is selected on the runctl page. Code was added under Institution fieldchange and rowinit to populate the currency_cd field. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: AV_OPR_DEF_TBL.INSTITUTION Prompt Table: AV_INST_SCRTY |
| 4 | PROCESS_DATE | Date(10) | DATE |
Process Date
Default Value: %Date |
| 5 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 7 | COMMIT_LEVEL | Number(5,0) | INTEGER NOT NULL |
Commit Level
Default Value: 100 |
| 8 | AV_GCLUB_PRCS | Character(1) | VARCHAR2(1) NOT NULL |
Process Giving Clubs
A=Initialize All Giving Clubs S=Initialize Select Giving Clubs U=Unprocessed Sessions Default Value: U |
| 9 | AV_INC_MAN_MGD_MEM | Character(1) | VARCHAR2(1) NOT NULL |
Flag to signify whether manually managed gifts are to be included during the Gift initialization process (AVPGCLUB).
Y/N Table Edit Default Value: N |