PROBINSTSYNCIDDIALOG_IDSID_TF_QTRF=Female
M=Male
U=Unknown
RY_EE_INP_VW(SQL View) |
Index Back |
|---|---|
WFC Survey Analyst Report ViewWorkforce Connect - This is a view used to display Survey Analysis Report data. |
| SELECT K.PROBINST , A.SYNCID , A.DIALOG_ID , A.SID_TF_QTR , A.SID_TF_ANN , A.SID_DEPT , A.SID_JOBCODE , A.SID_LOCATION , A.SEX , A.COUNTRY , A.REVIEW_RATING , A.AGE_GRP_ID , A.YRS_SVC_GRP_ID , A.RY_SRVY_SCORE , 1 FROM PS_RY_EE_FACT A , PS_RY_EE_PARM_RJC K WHERE A.BUSINESS_UNIT = K.BUSINESS_UNIT AND A.DIALOG_ID = K.DIALOG_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROBINST |
Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 2 | SYNCID |
Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 3 | DIALOG_ID |
Number(18,0) | DECIMAL(18) NOT NULL | Dialog ID field to identify both design time and run time dialog. |
| 4 | SID_TF_QTR |
Character(31) | VARCHAR2(31) NOT NULL | Workforce Connect - SetID Timeframe Quarter |
| 5 | SID_TF_ANN | Character(31) | VARCHAR2(31) NOT NULL | Workforce Connect - SetID Timeframe Annual |
| 6 | SID_DEPT | Character(21) | VARCHAR2(21) NOT NULL | Workforce Connect - SetID_Department |
| 7 | SID_JOBCODE | Character(21) | VARCHAR2(21) NOT NULL | Workforce Connect - SetID JobCode |
| 8 | SID_LOCATION | Character(21) | VARCHAR2(21) NOT NULL | Workforce Connect - Concatenated key for LOCATION_TBL |
| 9 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender of the person.
F=Female M=Male U=Unknown |
| 10 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 11 | REVIEW_RATING | Character(1) | VARCHAR2(1) NOT NULL | REVIEW_RATING field used in the HCM/ CRM sync Application Messages. |
| 12 | AGE_GRP_ID | Character(3) | VARCHAR2(3) NOT NULL | Workforce Connect - Age Group ID |
| 13 | YRS_SVC_GRP_ID | Character(3) | VARCHAR2(3) NOT NULL | Workforce Connect - Years Employed |
| 14 | RY_SRVY_SCORE | Signed Number(19,0) | DECIMAL(18) NOT NULL | Survey Overall score -- overall running score for a survey instance. |
| 15 | RY_RESPONDENTS | Number(10,0) | DECIMAL(10) NOT NULL | Field used by Online Marketing. |