ST_INSTANCEDefault Value: 9999999999
A=Addition
C=Correction
R=Replacement
Default Value: R
Default Value: %Datetime
0=Not Submitted
1=Submitted to Reported Time
2=Submitted to Time Admin.
3=Need to Resubmit the Session
Default Value: 0
FO_TL_RPDHD_UPG(SQL Table) |
Index Back |
|---|---|
T&L Rapid Entry HeaderT&L Rapid Entry Header Record for Release 8.0 + |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ST_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL |
Submit Time Instance
Default Value: 9999999999 |
| 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 Admin. 3=Need to Resubmit the Session Default Value: 0 |
| 8 | ST_INSTANCE_OLD | Number(10,0) | DECIMAL(10) NOT NULL | Session Number |