FIELDNAMESCH_MNG_TR_DATA(SQL View) |
Index Back |
|---|---|
Time Reporting ElementsPrompt table for Time Reporting Elements |
| SELECT A.FIELDNAME , B.LONGNAME FROM PSRECFIELD A ,PSDBFLDLABL B WHERE RECNAME ='TL_TR_SBR' AND A.FIELDNAME = B.FIELDNAME AND DEFAULT_LABEL=1 AND A.FIELDNAME NOT IN ('TL_QUANTITY','COMP_RATECD','CURRENCY_CD','OVERRIDE_RATE','TL_COMMENTS' ,'RULE_ELEMENT_1','RULE_ELEMENT_2','RULE_ELEMENT_3','RULE_ELEMENT_4','RULE_ELEMENT_5' ,'OVERRIDE_RSN_CD') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 2 | LONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Long Name |