GPCH_BL_PRINT(SQL View) |
Index Back |
|---|---|
Pay Slip Print OptionsPay Slip Print Options |
| SELECT %Substring(SAT.GP_ELN_ATTR1 ,1 ,8) , PAT.PIN_NUM , 'A' , EMB.ENTRY_TYPE_ID , %Substring(PAT.GP_ELN_ATTR1 ,1 ,1) , TO_NUMBER(%Substring(PAT.GP_ELN_ATTR10 ,1 ,2)) , TO_NUMBER(%Substring(PAT.GP_ELN_ATTR3 ,1 ,6)) , TO_NUMBER(%Substring(PAT.GP_ELN_ATTR2 ,1 ,2)) , %Substring(PAT.GP_ELN_ATTR4 ,1 ,1) , %Substring(PAT.GP_ELN_ATTR5 ,1 ,1) , %Substring(PAT.GP_ELN_ATTR6 ,1 ,1) , %Substring(PAT.GP_ELN_ATTR7 ,1 ,1) , %Substring(PAT.GP_ELN_ATTR8 ,1 ,1) , %Substring(PAT.GP_ELN_ATTR9 ,1 ,1) FROM PS_GP_ELN_SET_ATTR SAT , PS_GP_ELN_PIN_ATTR PAT , PS_GP_ELEM_GRP_MBR EMB WHERE SAT.GP_ELN_SET = PAT.GP_ELN_SET AND SAT.EFFDT = PAT.EFFDT AND SAT.COUNTRY = SAT.COUNTRY AND SAT.COUNTRY = 'CHE' AND PAT.PIN_ELEM_GRP_NUM = EMB.PIN_NUM AND PAT.PIN_NUM = EMB.PIN_ELEM_NUM AND PAT.EFFDT = EMB.EFFDT AND PAT.GP_ELN_ATTR3 <>' ' AND PAT.GP_ELN_ATTR2 <>' ' AND SAT.EFFDT = ( SELECT MAX(SAT1.EFFDT) FROM PS_GP_ELN_SET_ATTR SAT1 WHERE SAT.COUNTRY = SAT1.COUNTRY AND SAT.GP_ELN_SET = SAT1.GP_ELN_SET ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GPCH_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: GPCH_ENT_BL_VW |
| 5 | GPCH_AL_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL |
Override Indicator
Y/N Table Edit Default Value: N |
| 6 | GPCH_AL_SIGNVALUE | Signed Number(2,0) | DECIMAL(1) NOT NULL | Element Sign |
| 7 | GPCH_BL_PR_ORDER | Number(6,0) | INTEGER NOT NULL | Print Sequence |
| 8 | GPCH_BL_PR_GROUP | Number(2,0) | SMALLINT NOT NULL | Print Group |
| 9 | GPCH_BL_PR_CALC | Character(1) | VARCHAR2(1) NOT NULL |
To Print Calc_Rslt_Val if this field is checked.
Y/N Table Edit Default Value: N |
| 10 | GPCH_BL_PR_BASE | Character(1) | VARCHAR2(1) NOT NULL |
Print Base
Y/N Table Edit Default Value: N |
| 11 | GPCH_BL_PR_RATE | Character(1) | VARCHAR2(1) NOT NULL |
To Print Rate_Rslt_Val when this field is checked.
Y/N Table Edit Default Value: N |
| 12 | GPCH_BL_PR_UNITS | Character(1) | VARCHAR2(1) NOT NULL |
Print Units
Y/N Table Edit Default Value: N |
| 13 | GPCH_BL_PR_PERCENT | Character(1) | VARCHAR2(1) NOT NULL |
Print Percent
Y/N Table Edit Default Value: N |
| 14 | GPCH_BL_PR_SUM | Character(1) | VARCHAR2(1) NOT NULL |
Print Sum Amount
Y/N Table Edit Default Value: N |