HRS_SITE_IDPrompt Table: HRS_EXTSITE_PT
Prompt Table: PORTAL_NAME_VW
HRS_SITE_VW(SQL View) |
Index Back |
|---|---|
Site setup viewSite setup view: HRS_SITE_ID + HRS_SITE_CG |
| SELECT A.HRS_SITE_ID , A.HRS_EXT_ERP_SITE , A.PORTAL_NAME , B.MSGNODENAME , B.PORTAL_NAME_CREF , B.TGTNODE FROM PS_HRS_SITE_ID A , PS_HRS_SITE_CG B WHERE A.HRS_SITE_ID = B.HRS_SITE_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_SITE_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Site ID |
| 2 | HRS_EXT_ERP_SITE | Number(15,0) | DECIMAL(15) NOT NULL |
External ERP Site
Prompt Table: HRS_EXTSITE_PT |
| 3 | PORTAL_NAME | Character(30) | VARCHAR2(30) NOT NULL |
Portal Name (see PSPRDMDEFN).
Prompt Table: PORTAL_NAME_VW |
| 4 | MSGNODENAME | Character(30) | VARCHAR2(30) NOT NULL | Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN). |
| 5 | PORTAL_NAME_CREF | Character(30) | VARCHAR2(30) NOT NULL | Portal |
| 6 | TGTNODE | Character(30) | VARCHAR2(30) NOT NULL | Integration Server Business Entity ID |