SETIDMARKETASSIGN_GROUPCONFIG_CRITERIA_CDPNLGRPNAMER=Range
S=Single
PG=Provider Group ID
PR=Person ID
TM=Territory ID
RSF_ASSIGN_VW(SQL View) |
Index Back |
|---|---|
Assignment configuration view |
| SELECT A.SETID , A.MARKET , A.ASSIGN_GROUP , A.CONFIG_CRITERIA_CD , B.PNLGRPNAME , A.CRITERIA_FIELDNAME , A.CRITERIA_TYPE , A.ASSIGN_WEIGHT , B.OCCURSLEVEL , B.RECNAME_PRIMARY , B.RECNAME , B.FIELDNAME , A.REQUIRED_FLG , C.LAST_ASSIGNED_REC , C.LAST_ASSIGN_FIELD , C.CRIT_GROUP_FIELD , C.AVAILABILITY_REC , C.AVAILABILITY_FIELD , D.SINGLE_BU_FLG FROM PS_RSF_ASSIGN_CRIT A , PS_RSF_ASSIGN_COMP B , PS_RSF_ASSIGN_RECS C , PS_RSF_ASSIGN_GRP D WHERE A.SETID = B.SETID AND B.SETID = C.SETID AND A.MARKET = B.MARKET AND B.MARKET = C.MARKET AND A.ASSIGN_GROUP = B.ASSIGN_GROUP AND B.ASSIGN_GROUP = C.ASSIGN_GROUP AND A.CONFIG_CRITERIA_CD = B.CONFIG_CRITERIA_CD AND B.PNLGRPNAME = C.PNLGRPNAME AND D.SETID = A.SETID AND D.SETID = A.SETID AND D.MARKET = A.MARKET AND D.ASSIGN_GROUP = A.ASSIGN_GROUP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 2 | MARKET |
Character(3) | VARCHAR2(3) NOT NULL | Market |
| 3 | ASSIGN_GROUP |
Character(30) | VARCHAR2(30) NOT NULL | This field is used to specify assignment group name for Territory assignment. |
| 4 | CONFIG_CRITERIA_CD |
Character(10) | VARCHAR2(10) NOT NULL | Configurable Criteria Code |
| 5 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 6 | CRITERIA_FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Key Field |
| 7 | CRITERIA_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Criteria Type
R=Range S=Single |
| 8 | ASSIGN_WEIGHT | Number(2,0) | SMALLINT NOT NULL | Assignment Weight |
| 9 | OCCURSLEVEL | Number(1,0) | SMALLINT NOT NULL | Occurs level |
| 10 | RECNAME_PRIMARY | Character(15) | VARCHAR2(15) NOT NULL | Record Name |
| 11 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 12 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 13 | REQUIRED_FLG | Character(1) | VARCHAR2(1) NOT NULL | Required Flag |
| 14 | LAST_ASSIGNED_REC | Character(18) | VARCHAR2(18) NOT NULL | Last Assigned Record |
| 15 | LAST_ASSIGN_FIELD | Character(18) | VARCHAR2(18) NOT NULL | Last Assigned Field |
| 16 | CRIT_GROUP_FIELD | Character(2) | VARCHAR2(2) NOT NULL |
Criteria Group Field
PG=Provider Group ID PR=Person ID TM=Territory ID |
| 17 | AVAILABILITY_REC | Character(18) | VARCHAR2(18) NOT NULL | Availability Record |
| 18 | AVAILABILITY_FIELD | Character(18) | VARCHAR2(18) NOT NULL | Availability Field |
| 19 | SINGLE_BU_FLG | Character(1) | VARCHAR2(1) NOT NULL | Assign within Business Unit |