| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GPIT_RC_REPORTNAME |
Character(8) |
VARCHAR2(8) NOT NULL |
Print class
|
| 2 |
PIN_NUM |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
Prompt Table:
%RECNAME_EDIT
|
| 3 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 4 |
ENTRY_TYPE_ELEM |
Character(3) |
VARCHAR2(3) NOT NULL |
entry type element
Prompt Table:
GPIT_ENT_BL_VW
|
| 5 |
GPIT_AL_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override
Y/N Table Edit
Default Value: N
|
| 6 |
GPIT_AL_SIGNVALUE |
Signed Number(2,0) |
DECIMAL(1) NOT NULL |
Value of Sign
|
| 7 |
GPIT_BL_PR_ORDER |
Number(6,0) |
INTEGER NOT NULL |
Order
|
| 8 |
GPIT_BL_PR_GROUP |
Number(2,0) |
SMALLINT NOT NULL |
Print Group
|
| 9 |
GPIT_BL_PR_BASE |
Character(1) |
VARCHAR2(1) NOT NULL |
Base
Y/N Table Edit
Default Value: N
|
| 10 |
GPIT_BL_PR_AMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Amount
Y/N Table Edit
Default Value: Y
|
| 11 |
GPIT_BL_PR_PERCENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Percent
Y/N Table Edit
Default Value: N
|
| 12 |
GPIT_BL_PR_UNITS |
Character(1) |
VARCHAR2(1) NOT NULL |
Units
Y/N Table Edit
Default Value: N
|
| 13 |
GPIT_BL_PR_HOURS |
Character(1) |
VARCHAR2(1) NOT NULL |
Hours
Y/N Table Edit
Default Value: N
|
| 14 |
GPIT_BL_PR_FACTOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Factor
Y/N Table Edit
Default Value: N
|
| 15 |
GPIT_BL_PR_SUM |
Character(1) |
VARCHAR2(1) NOT NULL |
Sum
Y/N Table Edit
Default Value: N
|
| 16 |
GPIT_BL_PR_TOTAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Total
Y/N Table Edit
Default Value: N
|
| 17 |
GPIT_BL_PR_FIX_VAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Fix Value
Y/N Table Edit
Default Value: N
|
| 18 |
GPIT_BL_PR_BOXNO |
Number(3,0) |
SMALLINT NOT NULL |
Box NO
|
| 19 |
GPIT_BL_PR_CHK_BOX |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Box
Y/N Table Edit
Default Value: N
|
| 20 |
GPIT_BL_PR_PRT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
PRINT FLAG
Y/N Table Edit
Default Value: N
|
| 21 |
GPIT_BL_PT_COND_EX |
Character(1) |
VARCHAR2(1) NOT NULL |
Cond Ex
Y/N Table Edit
Default Value: N
|
| 22 |
GPIT_BL_PR_DESCR |
Character(20) |
VARCHAR2(20) NOT NULL |
Description
|
| 23 |
GPIT_CUDNOTE_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
CUD Note ID
Prompt Table:
GPIT_CUD_NOTE
|
| 24 |
GPIT_ASSOGGET |
Character(1) |
VARCHAR2(1) NOT NULL |
Subjection type
1=1 - INPS
2=2 - INPS and IRPEF
3=3 - IRPEF
4=4 - Not Subjected
|