BUSINESS_UNITEMPLIDEXTRA_ACCOUNT_NBRACCOUNT_SF_VW(SQL View) |
Index Back |
|---|---|
Account Sf ViewView of Account SF |
| SELECT DISTINCT A.BUSINESS_UNIT ,A.EMPLID ,A.ACCOUNT_NBR ,A.ACCOUNT_TYPE_SF ,B.ACCT_PER_TERM ,B.SETID FROM PS_ACCOUNT_SF A ,PS_ACCT_TYP_TBL_SF B WHERE B.SETID= ( SELECT DISTINCT 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 | EXTRA_ACCOUNT_NBR |
Character(10) | VARCHAR2(10) NOT NULL | Extra Account Nbr |
| 4 | ACCOUNT_TYPE_SF | Character(3) | VARCHAR2(3) NOT NULL | Account Type |
| 5 | ACCT_PER_TERM | Character(1) | VARCHAR2(1) NOT NULL | Account Per Term |
| 6 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |