RSF_ASSIGN_COMP

(SQL Table)
Index Back

Assignment Components

Define Components for Assignment Criteria.

# 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.

Default Value: OPR_DEF_TBL_RB.SETID

Prompt Table: SP_SETID_NONVW

2 MARKET Character(3) VARCHAR2(3) NOT NULL Market

Default Value: GBL

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

Prompt Table: RSF_COMP_DESCVW

6 OCCURSLEVEL Number(1,0) SMALLINT NOT NULL Occurs level

Prompt Table: RSF_COMP_LVL_VW

7 RECNAME_PRIMARY Character(15) VARCHAR2(15) NOT NULL Record Name

Prompt Table: RSF_COMP_RST_VW

8 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: RSF_COMP_REC_VW

9 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: RSF_COMP_FLD_VW

10 CRITERIA_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Key Field

Prompt Table: RSF_CRIT_FLD_VW

11 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
12 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
13 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
14 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
15 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
16 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time