GPAU_RC_SSTREAM(SQL Table) |
Index Back |
|---|---|
SuperStream Run ControlThis is the run control record for SuperStream reporting |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table: GP_PYENT_OPR_VW |
| 4 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table: GPAU_SS_RUN_VW |
| 5 | DATE_FROM | Date(10) | DATE | Date From |
| 6 | DATE_TO | Date(10) | DATE | Previous Period Date To |
| 7 | GPAU_NEG_ALLOW | Character(1) | VARCHAR2(1) NOT NULL |
Allow Negatives
Y/N Table Edit |
| 8 | GPAU_SS_RPT_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
SuperStream Report generation option
B=CSV & XBRL C=CSV Only X=XBRL Only Default Value: C |
| 9 | GPAU_XMLSET_REG | Character(5) | VARCHAR2(5) NOT NULL |
XML Set
Prompt Table: GPAU_SETREG_VW |
| 10 | GPAU_TMPLT_REG | Character(3) | VARCHAR2(3) NOT NULL |
Template type
Prompt Table: GPAU_TMLTREG_VW |
| 11 | GPAU_XMLSET_CTR | Character(5) | VARCHAR2(5) NOT NULL |
XML Set
Prompt Table: GPAU_SETCTR_VW |
| 12 | GPAU_TMPLT_CTR | Character(3) | VARCHAR2(3) NOT NULL |
Template type
Prompt Table: GPAU_TMLTCTR_VW |
| 13 | GPAU_XBRL_FILE | Character(200) | VARCHAR2(200) NOT NULL | XBRL File Name |
| 14 | URL_ID | Character(30) | VARCHAR2(30) NOT NULL |
URL Identifier (see PSURLDEFN).
Prompt Table: PSURLDEFN |
| 15 | GPAU_SINGLE_FILE | Character(1) | VARCHAR2(1) NOT NULL |
Generate Single CSV
Y/N Table Edit Default Value: N |