PROCESS_INSTANCEFS_MAP_IDPrompt Table: FS_MAP_HDR_TBL
Prompt Table: OPR_DEF_TBL_AP
D=DNB
E=EDI
FS_MAPPER_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | FS_MAP_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Map ID
Prompt Table: FS_MAP_HDR_TBL |
| 3 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPR_DEF_TBL_AP |
| 4 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 5 | FILE_PATH_NAME | Character(254) | VARCHAR2(254) NOT NULL | File Path |
| 6 | FILE_NAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 7 | FS_MAP_ARCHIVE | Character(124) | VARCHAR2(124) NOT NULL | Archived Directory |
| 8 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
| 9 | FS_MAP_CRITS | Long Character | CLOB | Criterias |
| 10 | FS_MAP_MSG | Character(254) | VARCHAR2(254) NOT NULL | Message |
| 11 | FS_MAP_MSG_TYP | Character(10) | VARCHAR2(10) NOT NULL | Message Type |
| 12 | FS_MAP_RET | Number(4,0) | SMALLINT NOT NULL | Result |
| 13 | FS_RET_DESRC | Character(254) | VARCHAR2(254) NOT NULL | Result Description |
| 14 | FS_MAP_RUN_ACT | Character(1) | VARCHAR2(1) NOT NULL |
Actions
D=DNB E=EDI |