PROCESS_INSTANCEC=Character
D=Date
N=Number
GM_PROP_AET(SQL Table) |
Index Back |
|---|---|
Grants Jetform Cache Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | PROPOSAL_ID | Character(25) | VARCHAR2(25) NOT NULL | Proposal ID |
| 4 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 5 | SEQ_NBR_3 | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 6 | VALUE_CHAR | Character(254) | VARCHAR2(254) NOT NULL | VALUE CHARACTER |
| 7 | VALUE_NUM | Number(14,3) | DECIMAL(13,3) NOT NULL | VALUE NUMBER |
| 8 | VALUE_DATE | Date(10) | DATE | VALUE DATE |
| 9 | SEG_ELEMENT | Character(20) | VARCHAR2(20) NOT NULL | Segment/Element |
| 10 | AE_STMT_SEG | Character(254) | VARCHAR2(254) NOT NULL | AE Statement Segment |
| 11 | AE_STMT_SEG1 | Character(254) | VARCHAR2(254) NOT NULL | AE Statement Segment |
| 12 | AE_STMT_SEG2 | Character(254) | VARCHAR2(254) NOT NULL | AE Statement Segment |
| 13 | AE_STMT_SEG3 | Character(254) | VARCHAR2(254) NOT NULL | AE Statement Segment |
| 14 | AE_STMT_SEG4 | Character(254) | VARCHAR2(254) NOT NULL | AE Statement Segment |
| 15 | AE_STMT_SEG5 | Character(254) | VARCHAR2(254) NOT NULL | AE Statement Segment |
| 16 | DATA_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
DATA_TYPE
C=Character D=Date N=Number |
| 17 | STEPNO | Number(5,0) | INTEGER NOT NULL | Step Number |
| 18 | FORM_ID | Character(6) | VARCHAR2(6) NOT NULL | Form Identification |
| 19 | AS_OF_DATE | Date(10) | DATE | As of Date |
| 20 | SORTID | Character(30) | VARCHAR2(30) NOT NULL | SortID |
| 21 | SORT_ELEMENT | Character(20) | VARCHAR2(20) NOT NULL | Sort Element |