EFFDTDefault Value: %date
GPAR_SIJP_CONCEPTPrompt Table: GPAR_ACMELM_VW
Default Value: N
GPAR_NRP_SIJ_VW(SQL View) |
Index Back |
|---|---|
SIJP layout parameters detailIntegrated retirement and pensions system layout parameters detail used to generate the interface. |
| SELECT EFFDT , GPAR_SIJP_CONCEPT , PIN_NUM + 50000000 , SYSTEM_DATA_FLG FROM PS_GPAR_SIJP_PARM1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 2 | GPAR_SIJP_CONCEPT |
Character(4) | VARCHAR2(4) NOT NULL | SIJP Layout Field |
| 3 | PIN_NUM | Number(8,0) | INTEGER NOT NULL |
PIN Number
Prompt Table: GPAR_ACMELM_VW |
| 4 | SYSTEM_DATA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Default Value: N |