EFFDTDefault Value: %date
Y/N Table Edit
Default Value: N
HR_MSS_CT_FLDVW(SQL View) |
Index Back |
|---|---|
Guided Self Service Fields VieShows the included fields for a GSS transaction. |
| SELECT A.HR_MSS_CT_NAME , A.EFFDT , A.RECNAME , A.FIELDNAME , A.INCLUDE_FLG , A.DISPLAY_FLG , A.REG_REGION FROM PS_HR_MSS_CT_FLDS A , PS_HR_MSS_CT_CFG B WHERE A.HR_MSS_CT_NAME=B.HR_MSS_CT_NAME AND A.REG_REGION = B.REG_REGION AND A.EFFDT = B.EFFDT AND B.STATUS='A' AND A.INCLUDE_FLG='Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HR_MSS_CT_NAME | Character(25) | VARCHAR2(25) NOT NULL | Compound Transaction Name |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 4 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 5 | INCLUDE_FLG | Character(1) | VARCHAR2(1) NOT NULL | include flag |
| 6 | DISPLAY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Display Only Flag
Y/N Table Edit Default Value: N |
| 7 | REG_REGION | Character(5) | VARCHAR2(5) NOT NULL | Regulatory Region |