INSTALLATION_BO(SQL Table) |
Index Back |
|---|---|
Install Options for BORM/CDMInstall Option Record for BORM/CDM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | UNIQUE_ID_PREFIX | Number(31,0) | DECIMAL(31) NOT NULL |
Unique ID Prefix
Default Value: 1 |
| 2 | CM_SRCH_FIRST_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Search For Existing
N=No Y=Yes Default Value: N |
| 3 | CM_SEARCH_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
CM_SEARCH_OPTN
Y/N Table Edit Default Value: Y |
| 4 | UPDATE_BO_DIR | Character(1) | VARCHAR2(1) NOT NULL |
Update BO Directory Online
Y/N Table Edit Default Value: Y |
| 5 | BO_DIR_LAST_UPDATE | DateTime(26) | TIMESTAMP | Last Directory Update Time |
| 6 | MOBILE_DEFAULT_ID | Character(5) | VARCHAR2(5) NOT NULL |
MOBILE_DEFAULT_ID
Prompt Table: RDM_MOBILE_DFLT |
| 7 | BO_DEDUP_FLAG | Number(1,0) | SMALLINT NOT NULL |
Perform BO Duplicate Check
N=No Y=Yes 1/0 Table Edit (1=True, 0=False) |
| 8 | BASIC_DATA_ENABLED | Character(1) | VARCHAR2(1) NOT NULL |
Enabled for Basic Data
N=No Y=Yes Default Value: N |
| 9 | ENFORCE_QCREATE | Character(1) | VARCHAR2(1) NOT NULL |
Enforce Quick Create Security
Y/N Table Edit Default Value: Y |
| 10 | ENABLE_BIND | Character(1) | VARCHAR2(1) NOT NULL |
Enable Binds for SQL generation
Y/N Table Edit Default Value: N |
| 11 | RELATIONSHIP_VIEW | Character(1) | VARCHAR2(1) NOT NULL |
RELATIONSHIP_VIEW
Y/N Table Edit Default Value: Y |
| 12 | THREE_SIXTY_VIEW | Character(1) | VARCHAR2(1) NOT NULL |
THREE_SIXTY_VIEW
Y/N Table Edit Default Value: Y |
| 13 | BO_SYS_STATUS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
System Status
D=In Development L=System is Live in Production P=In Platform Test S=In System Test Default Value: D |
| 14 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Prompt Table: SP_SETID_NONVW |
| 15 | SM_CONFIG_ID | Character(30) | VARCHAR2(30) NOT NULL | Search / Match Results Action Configuration Identifier |
| 16 | SM_ENABLE_SEARCH | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate whether Search/Match infrastructure is enabled for identifying individuals.
N=No Y=Yes Default Value: N |
| 17 | SCM_EIP | Character(1) | VARCHAR2(1) NOT NULL |
This field indicates whether SCM is integrated with CRM through EIP.
Y/N Table Edit Default Value: N |
| 18 | ABE_CONFIG_EIP | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate whether the Address Book Configuration should be considered when creating contact methods via EIPs.
N=No Y=Yes |
| 19 | EBS_EMPL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Newly Created Field for the Display of EBS HCM flag value in the customer Installation Page.
Y/N Table Edit Default Value: N |
| 20 | EMPL_EBS_DIS | Character(3) | VARCHAR2(3) NOT NULL |
New field is created for the EBS HCM flag based on this we will select the display option in the Customer Installation Page.
BID=Both EID=Only EBS Employee No PID=Only Peoplesoft Empl ID |
| 21 | RC_MAINT_OWNER | Character(1) | VARCHAR2(1) NOT NULL |
Call center Maintenance Owner
0=PeopleSoft 1=PeopleSoft / Customer Modified 2=Customer Default Value: 2 |
| 22 | SYSD_APPLICATION01 | Character(1) | VARCHAR2(1) NOT NULL |
PS CRM Core
N=No S=Sample Data Y=Yes Y/N Table Edit Default Value: N |
| 23 | SYSD_APPLICATION02 | Character(1) | VARCHAR2(1) NOT NULL |
Financial Services
N=No S=Sample Data Y=Yes Y/N Table Edit Default Value: N |
| 24 | SYSD_APPLICATION03 | Character(1) | VARCHAR2(1) NOT NULL |
Telecommunications
N=No S=Sample Data Y=Yes Y/N Table Edit Default Value: N |
| 25 | SYSD_APPLICATION04 | Character(1) | VARCHAR2(1) NOT NULL |
Government
N=No S=Sample Data Y=Yes Y/N Table Edit Default Value: N |
| 26 | SYSD_APPLICATION05 | Character(1) | VARCHAR2(1) NOT NULL |
Energy
N=No S=Sample Data Y=Yes Y/N Table Edit Default Value: N |
| 27 | SYSD_APPLICATION06 | Character(1) | VARCHAR2(1) NOT NULL |
Insurance
N=No S=Sample Data Y=Yes Y/N Table Edit Default Value: N |
| 28 | SYSD_APPLICATION07 | Character(1) | VARCHAR2(1) NOT NULL |
High Technology
N=No S=Sample Data Y=Yes Y/N Table Edit Default Value: N |
| 29 | SYSD_APPLICATION08 | Character(1) | VARCHAR2(1) NOT NULL |
HR HelpDesk
N=No S=Sample Data Y=Yes Y/N Table Edit Default Value: N |
| 30 | SYSD_APPLICATION09 | Character(1) | VARCHAR2(1) NOT NULL |
System Data Field for Application 9. Application 9 is used for Wealth Management.
N=No S=Sample Data Y=Yes Y/N Table Edit Default Value: N |
| 31 | SYSD_APPLICATION10 | Character(1) | VARCHAR2(1) NOT NULL |
Used in Application 10
N=No S=Sample Data Y=Yes Y/N Table Edit Default Value: N |
| 32 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 33 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 34 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 35 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 36 | 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. |
| 37 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |