FIELDNAMESCH_MNG_TD_DATA(SQL View) |
Index Back |
|---|---|
Task DataPrompt table for displaying Task Data Elements |
| SELECT A.FIELDNAME , B.LONGNAME FROM PSRECFIELD A ,PSDBFLDLABL B WHERE RECNAME IN ('TL_TASK_SBR','TL_TR_SCH_SBR') AND A.FIELDNAME = B.FIELDNAME AND DEFAULT_LABEL=1 AND A.FIELDNAME NOT IN('SETID_ACTIVITY','SETID_DEPT', 'SETID_JOBCODE','SETID_LOCATION','SETID_RESOURCE', 'BILLABLE_IND','COMP_RATECD','COUNTRY','CURRENCY_CD','LOCALITY','OVERRIDE_RATE','TL_COMMENTS','RULE_ELEMENT_1', 'RULE_ELEMENT_2','RULE_ELEMENT_3','RULE_ELEMENT_4','RULE_ELEMENT_5','STATE','TRC','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 |