BUSINESS_UNITDefault Value: OPR_DEF_TBL_CS.BUSINESS_UNIT
Prompt Table: SP_BU_SF_NONVW
EMPLIDDefault Value: NEW
Prompt Table: PERSONAL_DATA
SSF_ACCT_BAL_VW(SQL View) |
Index Back |
|---|---|
Pending Bill Balace ViewProvides the Pending Bill Balace View |
| SELECT a.BUSINESS_UNIT ,a.EMPLID ,SUM(a.LINE_AMT) FROM PS_ITEM_LINE_SF A WHERE A.BILLING_FLAG = 'N' GROUP BY a.BUSINESS_UNIT, a.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT Prompt Table: SP_BU_SF_NONVW |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: NEW Prompt Table: PERSONAL_DATA |
| 3 | ACCOUNT_BALANCE | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Account Balance |