COUNTRYPrompt Table: GP_COUNTRY
GP_RPT_IDPROCESS_INSTANCEGP_RPT_MODE1=Batch (Application Engine)
2=Script (Data Mover)
3=Real Time (PeopleCode)
OPRIDSEQ_NUMGP_RPT_LOG(SQL Table) |
Index Back |
|---|---|
Report Data Log FileReport Data Log File |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: GP_COUNTRY |
| 2 | GP_RPT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Extraction Process Name |
| 3 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 4 | GP_RPT_MODE |
Character(1) | VARCHAR2(1) NOT NULL |
Extraction Mode
1=Batch (Application Engine) 2=Script (Data Mover) 3=Real Time (PeopleCode) |
| 5 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 6 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 7 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 8 | TIME_STAMP | DateTime(26) | TIMESTAMP | Time Stamp |
| 9 | TIME_ELAPSED | Number(15,0) | DECIMAL(15) NOT NULL | Elapsed Time (in milliseconds) |
| 10 | ROW_COUNT | Number(8,0) | INTEGER NOT NULL | Number to Purge |