GPAR_NRP_S2J_VW(SQL View) |
Index Back |
---|---|
SIJP layout parameters detailIntegrated retirement and pensions system layout parameters detail used to generate the interface. |
SELECT EFFDT , EMPSIT_CD_ARG ,GPAR_SIJP_TYPE ,ACTION ,ACTION_REASON , PIN_NUM + 50000000 FROM PS_GPAR_SIJP_PARM2 |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
2 | EMPSIT_CD_ARG | Character(2) | VARCHAR2(2) NOT NULL |
Country Extension Argentine - Employee Situation Code Field
Prompt Table: EMPSIT_TBL_ARG |
3 | GPAR_SIJP_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Situation Code Type
AT=Absence Take JO=Job |
4 | ACTION | Character(3) | VARCHAR2(3) NOT NULL |
Action
Prompt Table: ACTION_TBL |
5 | ACTION_REASON | Character(3) | VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table: ACTN_REASON_TBL |
6 | PIN_NUM | Number(8,0) | INTEGER NOT NULL |
PIN Number
Prompt Table: GPAR_ATELM_VW |