GPIT_CTRRP_NRVW(SQL View) |
Index Back |
|---|---|
Contribution Report RecordContribution Report Record |
| SELECT GPIT_SECTION_ID , GPIT_SEQ_NUM , DESCR , GPIT_SIGN , GPIT_CTRRP_EL_TYP , GPIT_ENTRY_TYPE , GPIT_PIN_NUM + 50000000 , GPIT_SIGN1 , GPIT_CTRRP_EL_TYP1 , GPIT_ENTRY_TYPE1 , GPIT_PIN_NUM1 + 50000000 FROM PS_GPIT_CTRRP_ELM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GPIT_SECTION_ID |
Character(16) | VARCHAR2(16) NOT NULL | Section ID |
| 2 | GPIT_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | GPIT_SIGN | Character(1) | VARCHAR2(1) NOT NULL |
Sign
A=Add S=Subtract |
| 5 | GPIT_CTRRP_EL_TYP | Character(1) | VARCHAR2(1) NOT NULL |
Contribution Report Element Type
A=Amount B=Base and Amount Default Value: A |
| 6 | GPIT_ENTRY_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Entry Type
Prompt Table: GPIT_CTRRP_VW |
| 7 | GPIT_PIN_NUM | Number(8,0) | INTEGER NOT NULL |
Pin Number
Prompt Table: %RECNAME_EDIT |
| 8 | GPIT_SIGN1 | Character(1) | VARCHAR2(1) NOT NULL |
Sign
A=Add S=Subtract |
| 9 | GPIT_CTRRP_EL_TYP1 | Character(1) | VARCHAR2(1) NOT NULL |
Contribution Report Element Type
A=Amount B=Base and Amount Default Value: A |
| 10 | GPIT_ENTRY_TYPE1 | Character(3) | VARCHAR2(3) NOT NULL |
Entry Type
Prompt Table: GPIT_CTRRP_VW |
| 11 | GPIT_PIN_NUM1 | Number(8,0) | INTEGER NOT NULL |
Pin Number
Prompt Table: %RECNAME_EDIT2 |