PTAI_CONTEXT(SQL Table) |
Index Back |
---|---|
AI Context Data |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PTAI_LIST_ID | Character(31) | VARCHAR2(31) NOT NULL | Action Items - Action Item List ID |
2 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: PSRECFIELDALL |
3 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFNPVW |
4 | PTAI_KEY_LABEL | Character(100) | VARCHAR2(100) NOT NULL | Label |
5 | PTAI_KEY_VALUE | Character(254) | VARCHAR2(254) NOT NULL | Value |
6 | PTAI_CTX_KEY | Character(1) | VARCHAR2(1) NOT NULL |
Key Field
N=No Y=Yes Default Value: Y |
7 | PTAI_CTX_VISBL | Character(1) | VARCHAR2(1) NOT NULL |
Context Visible
Y/N Table Edit Default Value: N |
8 | PTAI_PARAM_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Parameter Type
F=Fixed Value I=Image Value R=Runtime S=System Variable Default Value: R |
9 | PTAI_PRIMARY_DATA | Character(1) | VARCHAR2(1) NOT NULL |
Primary Data
Y/N Table Edit Default Value: N |
10 | PTAI_LABEL_CHK | Character(1) | VARCHAR2(1) NOT NULL |
Label Visible
Y/N Table Edit Default Value: N |
11 | PTAI_IMAGE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Image Type
A=App Class M=Image Catalog N=None S=Static Default Value: N |
12 | PTAI_IMG_URL | Character(254) | VARCHAR2(254) NOT NULL | Static URL |
13 | PTAI_IMG_NAME | Character(254) | VARCHAR2(254) NOT NULL | Image Name/URL |
14 | PTAI_IMG_PACKAGE | Character(30) | VARCHAR2(30) NOT NULL | Application Package |
15 | PTAI_IMG_PATH | Character(127) | VARCHAR2(127) NOT NULL | Class Path |
16 | PTAI_IMG_CLASSID | Character(30) | VARCHAR2(30) NOT NULL | Class Name |
17 | PTAI_IMG_METHOD | Character(60) | VARCHAR2(60) NOT NULL | Method Name |