HCB_COND_FRML_D(SQL Table) |
Index Back |
|---|---|
Condition formulaChatBot conditional formula |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(11) | VARCHAR2(11) NOT NULL | External Job Applicant ID | |
| 2 | Character(15) | VARCHAR2(15) NOT NULL | Module ID | |
| 3 | Character(12) | VARCHAR2(12) NOT NULL | Transaction ID | |
| 4 | Character(1) | VARCHAR2(1) NOT NULL |
Action Types
A=Ask Questions C=PeopleCode D=Delete O=Other U=Update V=Display |
|
| 5 | Character(1) | VARCHAR2(1) NOT NULL |
GPCB Source Type
Q=PSQuery R=Record |
|
| 6 | Number(3,0) | SMALLINT NOT NULL | Key Position | |
| 7 | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: HCB_QRYFLD_VW |
|
| 8 | Number(2,0) | SMALLINT NOT NULL | Index Count | |
| 9 | Character(15) | VARCHAR2(15) NOT NULL | Scroll Name | |
| 10 | FIELDNAME1 | Character(18) | VARCHAR2(18) NOT NULL |
Field Name 1
Prompt Table: HCB_PSFIELD2_VW |
| 11 | HCB_DATA_SOURCE | Character(30) | VARCHAR2(30) NOT NULL | Chatbot Data Source |
| 12 | HCB_FLD_FMT1 | Number(2,0) | SMALLINT NOT NULL |
Field format for types
1=Character 2=Date 3=Monetary 4=Decimal 5=Element Pointer 6=Not Applicable |
| 13 | HCB_FM_OPERATOR | Character(1) | VARCHAR2(1) NOT NULL |
FM Operator
1=Null 2=Not Null 3=> 4=< 5=>= 6=<= 7== |
| 14 | HCB_FRML_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type
C=Character D=Date F=Field N=Number |
| 15 | HCB_NUM | Number(6,0) | INTEGER NOT NULL | Chat bot Number |
| 16 | HCB_CHAR | Character(30) | VARCHAR2(30) NOT NULL | Chat Bot Char |
| 17 | HCB_DATE | Date(10) | DATE | Chat Bot Date |
| 18 | FIELDNAME2 | Character(18) | VARCHAR2(18) NOT NULL |
Field Name 2
Prompt Table: HCB_PSFIELD2_VW |
| 19 | HCB_FLD_FMT2 | Number(2,0) | SMALLINT NOT NULL | Field format for types |
| 20 | OK_BUTTON | Character(1) | VARCHAR2(1) NOT NULL | OK... |
| 21 | CANCEL_BUTTON | Character(1) | VARCHAR2(1) NOT NULL | Cancel Button |
| 22 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data S=Sample Data Y=System Data |