HCB_COND_FRML_D(SQL Table) |
Index Back |
---|---|
Condition formulaChatBot conditional formula |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | HCB_APPLID | Character(11) | VARCHAR2(11) NOT NULL | External Job Applicant ID |
2 | HCB_MODULE_ID | Character(15) | VARCHAR2(15) NOT NULL | Module ID |
3 | HCB_ACTION_ID | Character(12) | VARCHAR2(12) NOT NULL | Transaction ID |
4 | HCB_ACTN_TYPE_CHT | Character(1) | VARCHAR2(1) NOT NULL |
Action Types
A=Ask Questions C=PeopleCode D=Delete O=Other U=Update V=Display |
5 | HCB_SRC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
GPCB Source Type
Q=PSQuery R=Record |
6 | KEYPOSN | Number(3,0) | SMALLINT NOT NULL | Key Position |
7 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: HCB_QRYFLD_VW |
8 | INDEXCOUNT | Number(2,0) | SMALLINT NOT NULL | Index Count |
9 | SCROLL_NAME | 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 |