OPRIDTRW_DATASRC_IDHCSC_APPCLASS_NAMEPrompt Table: TRW_APPCLASS_VW
METHODNAMEF=Fail
N=New
S=Success
TRW_DATASRC_TCL(SQL Table) |
Index Back |
|---|---|
TRW Data Source Test CalcsThis record stores Reward Item Calculations for a Reward Data Source test |
| # | 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 | TRW_DATASRC_ID |
Character(15) | VARCHAR2(15) NOT NULL | Total rewards statement - Reward Data Source ID |
| 3 | HCSC_APPCLASS_NAME |
Character(30) | VARCHAR2(30) NOT NULL |
This is a descriptive name for an application class.
Prompt Table: TRW_APPCLASS_VW |
| 4 | METHODNAME |
Character(32) | VARCHAR2(32) NOT NULL | Method Name |
| 5 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 6 | TRW_CALC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Calculation Status
F=Fail N=New S=Success |