|
InfoAccess |
|
| VIEW NAME | GL_DETAIL_STOUT |
| OVERVIEW |
This view contains General Ledger transaction detail by fiscal year for UW-Stout. |
| LOAD FREQUENCY | The data is updated and loaded every business day. |
DATA CUSTODIAN |
Director
of Accounting Services Ted Wenum |
| AUTHORIZATION |
You must receive approval to access data from the data custodian. For information about the authorization forms and the connections necessary, connect to the Infoaccess home page. |
| SPECIAL CONSIDERATIONS |
Key fields are identified with an asterisk (*) |
| QUESTIONS |
Contact: Division
of Information Technology Help Desk |
| LAST UPDATED | 11/01 Created |
| FIELD DEFINITIONS |
Key fields are identified
with an asterisk(*) |
| CHAR2(
N) or CHAR (N) or VARCHAR (N) - Alphanumeric field. (N) is the length of
the field. Field contains letters and/or numbers. Example: CHAR (5) could contain ‘ABC12’ or ‘12345’ or ‘ABCDEF’ (N) is the length of the field. Field contains letters and/or numbers. |
|
| NUM (N)
- Numeric field. (N) is the length of the field. Field contains only
numbers. Numbers with decimal points are represented as NUM (X.Y) X = total
number of digits Y = the number of decimals after the decimal Examples: NUM (6,2) could contain 2500.12 NUM (6) could contain 000005 or 550000 |
|
| DATE (XXXX)
- Date field. (XXXX) is the format of the field. Date can be in various
formats and date functions available based on your query tool can be used
against the field. Examples: DATE (YYMMDD); DATE (YYDDD); DATE (DD-MM-YY) |
Field Name |
Format |
Description |
|---|---|---|
|
Fiscal_ Year |
VarChar 4 |
Fiscal year transaction occurred. |
|
GL_Account_No |
VarChar 15 |
Account number transaction posted to. |
|
Posting_No |
VarChar 6 |
Sequential Posting Number attached to the Account ID on Datatel |
|
Fund |
VarChar 3 |
Transaction fund. |
|
Activity |
VarChar 1 |
Transaction activity code. |
|
Department |
VarChar 6 |
Transaction department number. |
|
Account_No |
VarChar 5 |
Transaction accounting number. |
|
SFS Fund_No |
VarChar 3 |
Translated from Datatel fund number for PeopleSoft Shared Financial System (SFS) |
|
SFS_ Account_No |
VarChar 4 |
Translated from Datatel object number PeopleSoft Shared Financial System (SFS) |
|
System_Date |
Date |
Date transaction entered on to system |
|
Transaction_Date |
Date |
Date transaction is posted for |
|
Posted_Date |
Date |
Date posted to GL system. |
|
Posted_No |
VarChar 10 |
Date and sequential number generated to tie to PeopleSoft Shared Financial System (SFS) (ie. 0701012234 is July 1st 2001 and sequence number 2234) |
|
Reference_No |
VarChar 10 |
Reference number |
|
Source_No |
VarChar 2 |
|
|
Source_Desc |
VarChar 30 |
Description of Source Number |
|
Transaction_desc |
VarChar 30 |
Description of Transaction |
|
Debit_amt |
Num (14,2) |
Debit amount of transaction |
|
Credit_amt |
Num (14,2) |
Credit amount of transaction |
|
Transaction Amt |
Num (14,2) |
Debit - Credit |
|
Term |
VarChar 8 |
Term the transaction is for. Relates to term for student transactions |
|
Journal_ID |
VarChar 2 |
SFS Journal ID |
|
Journal_No |
VarChar 8 |
SFS Journal Number |
|
Building_No |
VarChar 5 |
SFS Building Number |
|
SFS_Transaction_Flag |
VarChar 1 |
Y/N Transaction SFS type |
|
Reconcilation_Date |
Date |
Date transaction reconciled against to PeopleSoft Shared Financial System (SFS) |
|
Extract_Date_Time |
Date |
Date transaction loaded to table |