USF_CST_MAIN_VW(SQL View) |
Index Back |
|---|---|
USF New Cust Master Info |
| SELECT USF_UEID , USF_EFT_IND ,DUNS_NUMBER , %Substring(LEGAL_BUS_NAME, 1, 40) , %Substring(DBANAME, 1, 40) , %Substring(USF_CO_DIVISION, 1, 40) , %Substring(LEGAL_BUS_NAME, 1, 10) , 'FED' , ALC , DISBURSING_OFFICE , REGISTRATION_DT , REGISTRATION_DT , REGISTRATION_DT , EXPIRATION_DATE , %Substring(USF_URL, 1, 130) , USF_ENTITY_TYPE , USF_HIER_AGCYCD , REGISTRATION_DT , FILE_CREATE_DT FROM PS_USF_VNDR_HDR WHERE USF_AGENCY_BUS_PUR IN ('1','3') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  USF_UEID |
Character(12) | VARCHAR2(12) NOT NULL | Unique Entity Identifier |
| 2 | USF_EFT_IND |
Character(4) | VARCHAR2(4) NOT NULL | Entity EFT Indicator |
| 3 | DUNS_NUMBER | Character(9) | VARCHAR2(9) NOT NULL | DUNS Number |
| 4 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 5 | NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Name 2 |
| 6 | NAME3 | Character(40) | VARCHAR2(40) NOT NULL | Name 3 |
| 7 | NAMESHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Name |
| 8 | SOURCE_SYSTEM | Character(3) | VARCHAR2(3) NOT NULL |
Source System
CCR=CCR EBL=eBill Contact Maintenance FED=FED PEN=Pension Customer |
| 9 | ALC | Character(8) | VARCHAR2(8) NOT NULL | Agency Location Code |
| 10 | DISBURSING_OFFICE | Character(5) | VARCHAR2(5) NOT NULL | Field used by Payables |
| 11 | CUST_STATUS_DT | Date(10) | DATE | Customer Status Date |
| 12 | ADD_DT | Date(10) | DATE | Customer Added On |
| 13 | SINCE_DT | Date(10) | DATE | Customer Since |
| 14 | EXPIRATION_DATE | Date(10) | DATE | Expiration Date |
| 15 | WEB_URL | Character(130) | VARCHAR2(130) NOT NULL | Website URL |
| 16 | USF_ENTITY_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Entity Structure
2A=U.S. Government Entity 2J=Sole Proprietorship 2K=Partnership 2L=Corporate Entity 8H=Tax Exempt Corporate CY=Foriegn Government X6=International Organization ZZ=Other |
| 17 | USF_HIER_AGCYCD | Character(4) | VARCHAR2(4) NOT NULL | Department Code |
| 18 | REGISTRATION_DT | Date(10) | DATE | Registration Date |
| 19 | FILE_CREATE_DT | Date(10) | DATE | File Creation Date |