SETID1ACCOUNTPE_EXCL_ACCT_VW(SQL View) |
Index Back |
|---|---|
PE Excluded Account ViewThis view is used for prompting on the PE Accruals Option excluded accounts page. It retrieves the maximum effective dated account value where there is atleast one effective dated row that is active. |
| SELECT A.SETID , A.ACCOUNT , A.DESCR , A.DESCRSHORT , A.ACCOUNT_TYPE , A.BUDGETARY_ONLY FROM PS_GL_ACCOUNT_TBL A WHERE A.EFFDT= ( SELECT MAX(B.EFFDT) FROM PS_GL_ACCOUNT_TBL B WHERE B.SETID=A.SETID AND B.ACCOUNT=A.ACCOUNT AND B.EFF_STATUS<>'I') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID1 |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | ACCOUNT |
Character(10) | VARCHAR2(10) NOT NULL | Account |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | ACCOUNT_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Identifies a category of accounts that appears on the balance sheet or income statement of the enterprise. Each general ledger account (ACCOUNT) is associated with an account type (also called a ""monetary account type""). PeopleSoft delivers standard account types such as asset, liability, expense, and revenue. |
| 6 | BUDGETARY_ONLY | Character(1) | VARCHAR2(1) NOT NULL | Budgetary Only |