GPIT_DM10_GROUPEFFDTDefault Value: %date
GPIT_DM10_SEQ_NBRA=Amount Element Component
B=Base Element Component
R=Rate Element Component
U=Unit Element Component
Default Value: U
Prompt Table: GPIT_DM10_VW
Prompt Table: %RECNAME_EDIT
GPIT_DM_CL_NRVW(SQL View) |
Index Back |
|---|---|
DM10 Credit ElementsElements on DM10 Square D |
| SELECT GPIT_DM10_GROUP , EFFDT ,GPIT_DM10_SEQ_NBR ,GPIT_DM10_COMP_ELM ,GPIT_DM10_ELM_TYPE , GPIT_PIN_DM10_NUM + 50000000 FROM PS_GPIT_DM10_CLAIM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPIT_DM10_GROUP |
Character(4) | VARCHAR2(4) NOT NULL | DM10 Group Code. |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | GPIT_DM10_SEQ_NBR |
Number(5,0) | INTEGER NOT NULL | DM10 Group Sequence Number.... |
| 4 | GPIT_DM10_COMP_ELM | Character(1) | VARCHAR2(1) NOT NULL |
Component Element
A=Amount Element Component B=Base Element Component R=Rate Element Component U=Unit Element Component Default Value: U |
| 5 | GPIT_DM10_ELM_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
DM10 element type....
Prompt Table: GPIT_DM10_VW |
| 6 | GPIT_PIN_DM10_NUM | Number(8,0) | INTEGER NOT NULL |
DM10 Report Element Number
Prompt Table: %RECNAME_EDIT |