TIME_RPTR_INDE=Elapsed Time Reporter
P=Punch Time Reporter
RAPID_TMPLT_IDFO_RAPD_TMP_VW(SQL View) |
Index Back |
|---|---|
Rapid Template type ViewRapid Template View of Template type. This view list the rapid templates based on the template type selected. |
| SELECT TIME_RPTR_IND ,RAPID_TMPLT_ID ,DESCR FROM PS_TL_RPDTME_TMPLT WHERE TRC_FLAG = 'Y' AND BUS_UNIT_PC_FLAG = 'Y' AND PROJECT_ID_FLAG = 'Y' AND ACTIVITY_FLAG = 'Y' AND OVRD_RT_FLAG = 'Y' AND BILLIND_FLAG = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TIME_RPTR_IND |
Character(1) | VARCHAR2(1) NOT NULL |
Indicates whether a Time Reporter is primarily reports Elapsed Time or Punch Time.
E=Elapsed Time Reporter P=Punch Time Reporter |
| 2 | RAPID_TMPLT_ID |
Character(10) | VARCHAR2(10) NOT NULL | Rapid Time Template |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |