KK_TRAN_IDKK_TRAN_DTKK_TRAN_LNLEDGER_GROUPEXCPTN_TYPEKK_XCP_TRAN_VW3(SQL View) |
Index Back |
|---|---|
Comm Cntrl Budget Excptn LinesThis view extracts the Commitment Control Transaction Lines that contain exceptions. This is used on the Budget Exception Secondary panel drilldown for the grid. It retrieves lines with all exceptions for a single budget and Source transaction header. |
| SELECT A.KK_TRAN_ID ,A.KK_TRAN_DT ,A.KK_TRAN_LN ,A.LEDGER_GROUP ,A.EXCPTN_TYPE ,A.BUSINESS_UNIT ,A.ACCOUNT , A.DEPTID , %subrec(CF12_AN_SBR, A) ,%subrec(cfcc1_an_sbr,A) , A.STATISTICS_CODE FROM PS_KK_EXCPTN_TBL A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | KK_TRAN_ID |
Character(10) | VARCHAR2(10) NOT NULL | Commitment Control Foreign Key for Transaction Identification. |
| 2 | KK_TRAN_DT |
Date(10) | DATE | Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID. |
| 3 | KK_TRAN_LN |
Number(9,0) | DECIMAL(9) NOT NULL | Commitment Control Transaction Line number. |
| 4 | LEDGER_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 5 | EXCPTN_TYPE |
Character(3) | VARCHAR2(3) NOT NULL | Exception Type |
| 6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 7 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 8 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 9 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL | Operating Unit ChartField |
| 10 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL | Product ChartField |
| 11 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL | Fund Code |
| 12 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL | Class Field |
| 13 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL | Program Code ChartField |
| 14 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL | Budget Reference |
| 15 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL | Affiliate |
| 16 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL | IntraUnit Affiliate1 |
| 17 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL | Operating Unit Affiliate |
| 18 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL | Expansion chartfield 1 |
| 19 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 2 |
| 20 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 3 |
| 21 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 22 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 23 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 24 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
| 25 | BUDGET_PERIOD | Character(8) | VARCHAR2(8) NOT NULL | Budget Period |
| 26 | STATISTICS_CODE | Character(3) | VARCHAR2(3) NOT NULL | Statistics Code |