CTA_TMP(SQL Table) |
Index Back |
|---|---|
CTA /1220 Temp TableTemp table used by GLCTAGEN.SQR |
| # | 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 | ALC | Character(8) | VARCHAR2(8) NOT NULL | Agency Location Code |
| 4 | PERIOD_CTR | Number(12,0) | DECIMAL(12) NOT NULL | Period Counter |
| 5 | COLLECT_DISBURSE | Character(1) | VARCHAR2(1) NOT NULL |
Collection or Disbursement Indicator
C=Collection D=Disbursement |
| 6 | SF224_SECTION | Character(1) | VARCHAR2(1) NOT NULL | SF224 Section Indicator - Section II or Section III |
| 7 | MONETARY_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account. |
| 8 | BUDGET_PERIOD | Character(8) | VARCHAR2(8) NOT NULL | Budget Period |
| 9 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 10 | ALTACCT | Character(10) | VARCHAR2(10) NOT NULL | Alternate Account |
| 11 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 12 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL | Operating Unit ChartField |
| 13 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL | Product ChartField |
| 14 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL | Fund Code |
| 15 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL | Class Field |
| 16 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL | Program Code ChartField |
| 17 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL | Budget Reference |
| 18 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL | Affiliate |
| 19 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL | IntraUnit Affiliate1 |
| 20 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL | Operating Unit Affiliate |
| 21 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL | Expansion chartfield 1 |
| 22 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 2 |
| 23 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 3 |
| 24 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 25 | LEGIS_REF_NBR | Character(27) | VARCHAR2(27) NOT NULL | Reference Number |
| 26 | TAS_GWA | Character(26) | VARCHAR2(26) NOT NULL | TAS GWA |
| 27 | ENTRY_EVENT | Character(10) | VARCHAR2(10) NOT NULL | Entry Event |
| 28 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 29 | FUND_SOURCE | Character(6) | VARCHAR2(6) NOT NULL | Funding Source |
| 30 | BETC_CD | Character(8) | VARCHAR2(8) NOT NULL | Business Event Type Code |