ST_INSTANCEA=Addition
C=Correction
R=Replacement
Default Value: R
Default Value: %Datetime
0=Not Submitted
1=Submitted to Reported Time
2=Submitted to Time Administrati
3=Need to Resubmit the Session
Default Value: 0
FO_RPD_HDR_VW(SQL View) |
Index Back |
|---|---|
T&L Rapid Entry HeaderT&L Rapid Entry Header Record for Release 8.0 + |
| SELECT H.ST_INSTANCE ,H.DESCR ,H.RAPID_TMPLT_ID ,H.TL_ADDREP_IND ,H.OPRID ,H.DTTM_STAMP ,H.RAPID_UPDATE_FLAG FROM PS_TL_RAPID_HEADER H |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ST_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Session Number |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | RAPID_TMPLT_ID | Character(10) | VARCHAR2(10) NOT NULL | Rapid Time Template |
| 4 | TL_ADDREP_IND | Character(1) | VARCHAR2(1) NOT NULL |
This field designates whether time should be added to or replace a particular day's time.
A=Addition C=Correction R=Replacement Default Value: R |
| 5 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 6 | DTTM_STAMP | DateTime(26) | TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
Default Value: %Datetime |
| 7 | RAPID_UPDATE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Session Status
0=Not Submitted 1=Submitted to Reported Time 2=Submitted to Time Administrati 3=Need to Resubmit the Session Default Value: 0 |