BUSINESS_UNITEMPLIDACCT_SF_VW(SQL View) |
Index Back |
|---|---|
Account SF ViewView of Account SF |
| SELECT A.BUSINESS_UNIT ,A.EMPLID ,A.ACCOUNT_NBR ,A.ACCOUNT_TERM ,A.ACCOUNT_BALANCE ,A.ACCOUNT_TYPE_SF ,B.UNAPP_PMT_CREDHIST ,B.EXCLUDE_AGE_FLG FROM PS_ACCOUNT_SF A ,PS_ACCT_TYP_TBL_SF B WHERE B.SETID= ( SELECT C.SETID FROM PS_SET_CNTRL_REC C WHERE C .SETCNTRLVALUE = A.BUSINESS_UNIT AND C.RECNAME='ACCT_TYP_TBL_SF') AND A.ACCOUNT_TYPE_SF = B.ACCOUNT_TYPE_SF |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | ACCOUNT_NBR | Character(10) | VARCHAR2(10) NOT NULL | Account Nbr |
| 4 | ACCOUNT_TERM | Character(4) | VARCHAR2(4) NOT NULL | Account Term |
| 5 | ACCOUNT_BALANCE | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Account Balance |
| 6 | ACCOUNT_TYPE_SF | Character(3) | VARCHAR2(3) NOT NULL | Account Type |
| 7 | UNAPP_PMT_CREDHIST | Character(1) | VARCHAR2(1) NOT NULL | View Unappld Pymt Credit Hist |
| 8 | EXCLUDE_AGE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Exclude From Aging Total |